
CREATE TABLE appellations (
	"No" INTEGER, 
	"Appelation" TEXT, 
	"County" TEXT, 
	"State" TEXT, 
	"Area" TEXT, 
	"isAVA" TEXT, 
	PRIMARY KEY ("No"), 
	UNIQUE ("Appelation")
)


CREATE TABLE grapes (
	"ID" INTEGER, 
	"Grape" TEXT, 
	"Color" TEXT, 
	PRIMARY KEY ("ID"), 
	UNIQUE ("Grape")
)


CREATE TABLE wine (
	"No" INTEGER, 
	"Grape" TEXT, 
	"Winery" TEXT, 
	"Appelation" TEXT, 
	"State" TEXT, 
	"Name" TEXT, 
	"Year" INTEGER, 
	"Price" INTEGER, 
	"Score" INTEGER, 
	"Cases" INTEGER, 
	"Drink" TEXT, 
	FOREIGN KEY("Grape") REFERENCES grapes ("Grape"), 
	FOREIGN KEY("Appelation") REFERENCES appellations ("Appelation")
)

CREATE TABLE appellations (
	"No" INTEGER, 
	"Appelation" TEXT, 
	"County" TEXT, 
	"State" TEXT, 
	"Area" TEXT, 
	"isAVA" TEXT, 
	PRIMARY KEY ("No"), 
	UNIQUE ("Appelation")
)

/*
2 rows from appellations table:
No	Appelation	County	State	Area	isAVA
1	Alexander Valley	Sonoma	California	North Coast	Yes
2	Amador County	Amador	California	Sierra Foothills	No
*/


CREATE TABLE grapes (
	"ID" INTEGER, 
	"Grape" TEXT, 
	"Color" TEXT, 
	PRIMARY KEY ("ID"), 
	UNIQUE ("Grape")
)

/*
2 rows from grapes table:
ID	Grape	Color
1	Barbera	Red
2	Cabernet Franc	Red
*/


CREATE TABLE wine (
	"No" INTEGER, 
	"Grape" TEXT, 
	"Winery" TEXT, 
	"Appelation" TEXT, 
	"State" TEXT, 
	"Name" TEXT, 
	"Year" INTEGER, 
	"Price" INTEGER, 
	"Score" INTEGER, 
	"Cases" INTEGER, 
	"Drink" TEXT, 
	FOREIGN KEY("Grape") REFERENCES grapes ("Grape"), 
	FOREIGN KEY("Appelation") REFERENCES appellations ("Appelation")
)

/*
2 rows from wine table:
No	Grape	Winery	Appelation	State	Name	Year	Price	Score	Cases	Drink
1	Zinfandel	Robert Biale	St. Helena	California	Old Kraft Vineyard	2008	44	93	275	now
2	Zinfandel	Chiarello Family	Napa Valley	California	Giana	2008	35	93	480	now
*/
What are the names and scores of wines that are made of white color grapes?
SELECT T2.Name ,   T2.Score FROM GRAPES AS T1 JOIN WINE AS T2 ON T1.Grape  =  T2.Grape WHERE T1.Color  =  "White"
[{'Name': 'Sauvignon Blanc', 'Score': 92}, {'Name': 'Les Pionniers', 'Score': 92}, {'Name': 'Cuvee Nicolas', 'Score': 91}, {'Name': 'Tradition', 'Score': 91}, {'Name': 'Church Vineyard', 'Score': 91}, {'Name': 'LApres-Midi', 'Score': 91}, {'Name': 'Rosemarys Block Dry Stack Vineyard', 'Score': 90}, {'Name': 'Sauvignon Blanc', 'Score': 90}, {'Name': 'Sauvignon Blanc', 'Score': 89}, {'Name': 'Sauvignon Blanc', 'Score': 89}, {'Name': 'Mesa Verde Vineyard', 'Score': 89}, {'Name': 'Sauvignon Blanc', 'Score': 89}, {'Name': 'Sauvignon Blanc', 'Score': 89}, {'Name': 'Sauvignon Blanc', 'Score': 89}, {'Name': 'Asatsuyu', 'Score': 89}, {'Name': 'Estate', 'Score': 89}, {'Name': 'Sauvignon Blanc', 'Score': 89}, {'Name': 'Home Ranch', 'Score': 89}, {'Name': 'Hyde Vineyards', 'Score': 89}, {'Name': 'Purisma Mountain', 'Score': 88}, {'Name': '3CV Grassini Family Vineyards', 'Score': 88}, {'Name': 'Schmidt Ranch', 'Score': 88}, {'Name': 'Sauvignon Blanc', 'Score': 87}, {'Name': 'Cuvee Natalie', 'Score': 87}, {'Name': 'au Naturel', 'Score': 87}, {'Name': 'Handley Vineyard', 'Score': 87}, {'Name': 'Wow Oui', 'Score': 87}, {'Name': 'Sauvignon Blanc', 'Score': 87}, {'Name': 'Sauvignon Blanc', 'Score': 87}, {'Name': 'Sauvignon Blanc', 'Score': 87}, {'Name': 'Sauvignon Blanc', 'Score': 87}, {'Name': 'Sauvignon Blanc', 'Score': 86}, {'Name': 'Magnolia Lane', 'Score': 86}, {'Name': 'Carols Vineyard', 'Score': 86}, {'Name': 'East Side Vineyards', 'Score': 86}, {'Name': 'Sauvignon Blanc', 'Score': 86}, {'Name': 'Sauvignon Blanc', 'Score': 85}, {'Name': 'Sauvignon Blanc', 'Score': 85}, {'Name': 'Sauvignon Blanc', 'Score': 85}, {'Name': 'Sauvignon Blanc', 'Score': 85}, {'Name': 'Chardonnay', 'Score': 92}, {'Name': 'La Cruz Vineyard', 'Score': 91}, {'Name': 'Chardonnay', 'Score': 86}, {'Name': 'Green River Isobel', 'Score': 95}, {'Name': 'Sengiacomo Vineyard', 'Score': 93}, {'Name': 'Lorenzo', 'Score': 93}, {'Name': 'Chloe', 'Score': 92}, {'Name': 'Chardonnay', 'Score': 90}, {'Name': 'Signature', 'Score': 90}, {'Name': 'Stagecoach Vineyard Black Bart', 'Score': 90}, {'Name': 'Home Ranch', 'Score': 90}, {'Name': 'Boonflys Hill', 'Score': 95}, {'Name': 'McCrea Vineyard', 'Score': 95}, {'Name': 'Ma Belle-Fille', 'Score': 95}, {'Name': 'Durell Vineyard', 'Score': 95}, {'Name': 'Durell Vineyard Wente Clone', 'Score': 95}, {'Name': 'Estate Vineyard', 'Score': 94}, {'Name': 'Wine Hill Vineyard', 'Score': 94}, {'Name': 'Belle Cote', 'Score': 94}, {'Name': 'Mon Plaisir', 'Score': 94}, {'Name': 'Untilited #3', 'Score': 94}, {'Name': 'Reserve', 'Score': 94}, {'Name': 'Los Alamos Vineyard Historic Vineyards Collection', 'Score': 93}, {'Name': 'Hyde Vineyards', 'Score': 93}, {'Name': 'Hudson Vineyard', 'Score': 93}, {'Name': 'Damaris Reserve ', 'Score': 93}, {'Name': 'Chardonnay', 'Score': 93}, {'Name': 'Cahrles Heintz Vineyard', 'Score': 93}, {'Name': 'Santa Cruz Mountains Estate', 'Score': 93}, {'Name': 'Red Shoulder Ranch', 'Score': 93}, {'Name': 'Winmakers Reserve', 'Score': 93}, {'Name': 'Sangiacomo Vineyard', 'Score': 92}, {'Name': 'Sbraglia Limited-Release', 'Score': 92}, {'Name': 'Chardonnay', 'Score': 92}, {'Name': 'Reserve', 'Score': 92}, {'Name': 'Chardonnay', 'Score': 92}, {'Name': 'Ryo-fu', 'Score': 92}, {'Name': 'Chardonnay', 'Score': 92}, {'Name': 'Carneros', 'Score': 92}, {'Name': 'Dutton Ranch', 'Score': 92}, {'Name': 'Chardonnay', 'Score': 92}, {'Name': 'Los Olivos Vineyard', 'Score': 92}, {'Name': 'La Carrlere', 'Score': 92}, {'Name': 'Chardonnay', 'Score': 92}, {'Name': 'Home Ranch', 'Score': 92}, {'Name': 'Chardonnay', 'Score': 92}, {'Name': 'Carneros', 'Score': 92}, {'Name': 'Chardonnay', 'Score': 92}, {'Name': 'Chardonnay', 'Score': 91}, {'Name': 'Keefer Ranch', 'Score': 91}, {'Name': 'Chardonnay', 'Score': 91}, {'Name': 'Private Reserve', 'Score': 91}, {'Name': 'Carneros Reserve', 'Score': 91}, {'Name': 'Chardonnay', 'Score': 91}, {'Name': 'Chardonnay', 'Score': 91}, {'Name': 'Chardonnay', 'Score': 91}, {'Name': 'Dutton Ranch', 'Score': 91}, {'Name': 'Chardonnay', 'Score': 91}, {'Name': 'Emelias Cuvee', 'Score': 91}, {'Name': 'Chardonnay', 'Score': 91}, {'Name': 'Ovation', 'Score': 91}, {'Name': 'Laughlin Family Vineyard', 'Score': 91}, {'Name': 'Don Miguel Vineyard Lia Torres Family Vineyards', 'Score': 91}, {'Name': 'Chardonnay', 'Score': 91}, {'Name': 'B. Theriot Vineyard', 'Score': 91}, {'Name': 'Ceja Vineyard', 'Score': 91}, {'Name': 'Chardonnay', 'Score': 91}, {'Name': 'Chardonnay', 'Score': 91}, {'Name': 'Chardonnay', 'Score': 91}, {'Name': 'Proprietary Reserve', 'Score': 91}, {'Name': 'Los Carneros', 'Score': 91}, {'Name': 'Chardonnay', 'Score': 90}, {'Name': 'Carneros', 'Score': 90}, {'Name': 'Chardonnay', 'Score': 90}, {'Name': 'Signature', 'Score': 90}, {'Name': 'Valley Dominique', 'Score': 90}, {'Name': 'Chardonnay', 'Score': 90}, {'Name': 'Founders', 'Score': 90}, {'Name': 'Kistler Vineyard', 'Score': 90}, {'Name': 'Gold Creek Ranch', 'Score': 90}, {'Name': 'Chardonnay', 'Score': 90}, {'Name': 'Cuvee Natalie', 'Score': 90}, {'Name': 'Chardonnay', 'Score': 90}, {'Name': 'Chardonnay', 'Score': 90}, {'Name': 'Chardonnay', 'Score': 90}, {'Name': 'De La Guerra', 'Score': 90}, {'Name': 'Parr Vineyard', 'Score': 90}, {'Name': 'Chardonnay', 'Score': 90}, {'Name': 'Carneros', 'Score': 88}, {'Name': 'Reserve', 'Score': 88}, {'Name': 'Chardonnay', 'Score': 88}, {'Name': 'Chardonnay', 'Score': 88}, {'Name': 'Chardonnay', 'Score': 88}, {'Name': 'Chardonnay', 'Score': 88}, {'Name': 'Chardonnay', 'Score': 87}, {'Name': 'Chardonnay', 'Score': 87}, {'Name': 'Chardonnay', 'Score': 87}, {'Name': 'Chardonnay', 'Score': 87}, {'Name': 'Finest Selection Reserve', 'Score': 86}, {'Name': 'Eterium B. Thieriot Vineyard', 'Score': 95}, {'Name': 'Chardonnay', 'Score': 93}, {'Name': 'Metallico Un-Oaked', 'Score': 91}, {'Name': 'Reserve', 'Score': 91}, {'Name': 'Russian River Selection', 'Score': 89}, {'Name': 'Chardonnay', 'Score': 89}, {'Name': 'Chardonnay', 'Score': 88}, {'Name': 'Sauvignon Blanc', 'Score': 93}, {'Name': 'Fume Blanc', 'Score': 88}, {'Name': 'Sauvignon Blanc', 'Score': 87}, {'Name': 'Lillie Vineyard', 'Score': 87}, {'Name': 'Sauvignon Blanc', 'Score': 86}, {'Name': 'To the Rescue', 'Score': 91}, {'Name': 'A by Acacia', 'Score': 81}]