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 average population across the counties?
assistant
SELECT AVG ( Population ) FROM county;
human
Which county's population is lowest?
assistant
SELECT county_name FROM county ORDER by population asc LIMIT 1;
human
What county has the highest population?
assistant
SELECT county_name FROM county ORDER by population desc LIMIT 1 ;