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
Tell me the Lieutenant Governor name for the year 1998 ?
assistant
SELECT Lieutenant_Governor FROM party WHERE year = '1998.0';
human
Who is the Delegate for the election id 1 ?
assistant
SELECT Delegate FROM election WHERE Election_ID = '1';
human
Show the name of the party that has the most delegates ?
assistant
SELECT T2.Party FROM election AS T1 JOIN party AS T2 ON T1.Party = T2.Party_ID GROUP BY T1.Party ORDER BY COUNT( * ) DESC LIMIT 1 ;