Hi, could you please show me the list of all appellations those produce wine after 2008?
select appelation from wine where year > 2008
That's a big list, thank you. Then could you please exclude Central Coast area from them?
select appelation from wine where year > 2008 except select appelation from appellations where area = "Central Coast"
That's great, thank you. Could you please show me the list of states where these appellations are located at?
select state from appellations where appelation in ( select appelation from wine where year > 2008 except select appelation from appellations where area = "Central Coast" )
Oh.. actually somewhat expected that. Thank you, then could you please let me know the average price of all wines?
select avg ( price ) from wine
Then could you please show me the list of wines those are more expensive than the average?
select * from wine where price > ( select avg ( price ) from wine )