human
Schema:
county (County_Id, County_name, Population, Zip_code)
party (Party_ID, Year, Party, Governor, Lieutenant_Governor, Comptroller, Attorney_General, US_Senate)
election (Election_ID, Counties_Represented, District, Delegate, Party, First_Elected, Committee)
Please answer with SQL.
assistant
Sure, I understand.
human
What is the zip code of county id of 2
assistant
SELECT zip_code FROM county WHERE county_id = 2;
human
how much population of zip code D21?
assistant
SELECT population FROM county WHERE zip_code = 'D21';
human
what is the county name zip code D02?
assistant
SELECT county_name FROM county WHERE zip_code = "D02" ;