what are all appellations?
select appelation from appellations
which of them are in the North Coast area?
select appelation from appellations where area = "North Coast"
Find the names of all distinct wines from those appellations.
select distinct t2.name from appellations as t1 join wine as t2 on t1.appelation = t2.appelation where t1.area = "North Coast"