How many gas station are opened between 2000 and 2005?
SELECT count(*) FROM gas_station WHERE open_year BETWEEN 2000 AND 2005
gas station opened between 2000 and 2005 refers to open_year BETWEEN 2000 AND 2005; count of gas stations refers to COUNT(*)