CREATE TABLE school_bus (school_id NUMBER, driver_id NUMBER, years_working NUMBER, if_full_time others)
CREATE TABLE driver (driver_id NUMBER, name CLOB, party CLOB, home_city CLOB, age NUMBER)
CREATE TABLE school (school_id NUMBER, grade CLOB, school CLOB, location CLOB, type CLOB)

Show the party and the number of drivers in each party.
SELECT party, COUNT(*) FROM driver GROUP BY party
SELECT "party", COUNT(*) FROM "driver" GROUP BY "party"