CREATE TABLE races (raceid NUMBER, year NUMBER, round NUMBER, circuitid NUMBER, name CLOB, date CLOB, time CLOB, url CLOB)
CREATE TABLE drivers (driverid NUMBER, driverref CLOB, number NUMBER, code CLOB, forename CLOB, surname CLOB, dob CLOB, nationality CLOB, url CLOB)
CREATE TABLE seasons (year NUMBER, url CLOB)
CREATE TABLE circuits (circuitid NUMBER, circuitref CLOB, name CLOB, location CLOB, country CLOB, lat NUMBER, lng NUMBER, alt NUMBER, url CLOB)
CREATE TABLE constructors (constructorid NUMBER, constructorref CLOB, name CLOB, nationality CLOB, url CLOB)
CREATE TABLE driverstandings (driverstandingsid NUMBER, raceid NUMBER, driverid NUMBER, points NUMBER, position NUMBER, positiontext CLOB, wins NUMBER)
CREATE TABLE pitstops (raceid NUMBER, driverid NUMBER, stop NUMBER, lap NUMBER, time CLOB, duration CLOB, milliseconds NUMBER)
CREATE TABLE constructorstandings (constructorstandingsid NUMBER, raceid NUMBER, constructorid NUMBER, points NUMBER, position NUMBER, positiontext CLOB, wins NUMBER)
CREATE TABLE results (resultid NUMBER, raceid NUMBER, driverid NUMBER, constructorid NUMBER, number NUMBER, grid NUMBER, position NUMBER, positiontext CLOB, positionorder NUMBER, points NUMBER, laps NUMBER, time CLOB, milliseconds NUMBER, fastestlap NUMBER, rank NUMBER, fastestlaptime CLOB, fastestlapspeed CLOB, statusid NUMBER)
CREATE TABLE status (statusid NUMBER, status CLOB)
CREATE TABLE constructorresults (constructorresultsid NUMBER, raceid NUMBER, constructorid NUMBER, points NUMBER, status NUMBER)
CREATE TABLE qualifying (qualifyid NUMBER, raceid NUMBER, driverid NUMBER, constructorid NUMBER, number NUMBER, position NUMBER, q1 CLOB, q2 CLOB, q3 CLOB)
CREATE TABLE laptimes (raceid NUMBER, driverid NUMBER, lap NUMBER, position NUMBER, time CLOB, milliseconds NUMBER)

How many drivers did not race in 2009?
SELECT COUNT(DISTINCT driverid) FROM results WHERE NOT raceid IN (SELECT raceid FROM races WHERE year <> 2009)
SELECT COUNT(DISTINCT "driverid") FROM "results" WHERE NOT "raceid" IN (SELECT "raceid" FROM "races" WHERE "year" <> 2009)