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
Can you show me the number of drivers who are from Hartford City?
assistant
SELECT COUNT( * ) FROM driver WHERE home_city = 'Hartford';
human
Oh, I want the names of the drivers.
assistant
SELECT name FROM driver WHERE home_city = 'Hartford';
human
Hmm, please show me names of the drivers who are younger than 40.
assistant
SELECT name FROM driver WHERE age < 40 ;