CREATE TABLE company (company_id NUMBER, rank NUMBER, company CLOB, headquarters CLOB, main_industry CLOB, sales_billion NUMBER, profits_billion NUMBER, assets_billion NUMBER, market_value NUMBER)
CREATE TABLE station_company (station_id NUMBER, company_id NUMBER, rank_of_the_year NUMBER)
CREATE TABLE gas_station (station_id NUMBER, open_year NUMBER, location CLOB, manager_name CLOB, vice_manager_name CLOB, representative_name CLOB)

What is the total number of gas stations that opened between 2000 and 2005?
SELECT COUNT(*) FROM gas_station WHERE open_year BETWEEN 2000 AND 2005
SELECT COUNT(*) FROM "gas_station" WHERE "open_year" <= 2005 AND "open_year" >= 2000