Wine_view1

create view wine_view1 as select distinct producer , appellation, type supplier, country, vintage from wineflat