Table schema:
CREATE TABLE races (name VARCHAR, YEAR INTEGER)

Question: What are the names of races held between 2009 and 2011?
SQL: SELECT name FROM races WHERE YEAR BETWEEN 2009 AND 2011