CREATE TABLE movie (mid DECIMAL, title TEXT, year DECIMAL, director TEXT)
CREATE TABLE rating (rid DECIMAL, mid DECIMAL, stars DECIMAL, ratingdate TIME)
CREATE TABLE reviewer (rid DECIMAL, name TEXT)

How many movies were made before 2000?
SELECT COUNT(*) FROM movie WHERE year < 2000
SELECT COUNT(*) FROM "movie" WHERE "year" < 2000