SELECT count(*) FROM Movie WHERE YEAR  <  2000
How many movies were made before 2000?
SELECT count ( * ) FROM Movie WHERE YEAR < 2000
select count ( * ) from movie where year < value
How many movies were made before 2000 ?