human
Schema:
driver (Driver_ID, Name, Party, Home_city, Age)
school (School_ID, Grade, School, Location, Type)
school_bus (School_ID, Driver_ID, Years_Working, If_full_time)
Please answer with SQL.
assistant
Sure, I understand.
human
How many drivers are there?
assistant
SELECT COUNT( * ) FROM driver;
human
How many drivers does each city have?
assistant
SELECT home_city , COUNT( * ) FROM driver GROUP BY home_city;
human
Which city has the most drivers?
assistant
SELECT home_city FROM driver GROUP BY home_city ORDER BY COUNT( * ) DESC LIMIT 1 ;