CREATE TABLE fires (fire_year NUMBER, discovery_date NUMBER, discovery_doy NUMBER, discovery_time CLOB, stat_cause_code NUMBER, stat_cause_descr CLOB, cont_date CLOB, cont_doy CLOB, cont_time CLOB, fire_size NUMBER, fire_size_class CLOB, latitude NUMBER, longitude NUMBER, owner_code NUMBER, owner_descr CLOB, state CLOB, county CLOB, fips_code CLOB, fips_name CLOB)

How many acres burned in fires in California each year between 2000 and 2005?
SELECT SUM(fire_size), fire_year FROM fires WHERE state = "CA" AND fire_year BETWEEN 2000 AND 2005 GROUP BY fire_year
SELECT SUM("fire_size"), "fire_year" FROM "fires" WHERE "CA" = "state" AND "fire_year" <= 2005 AND "fire_year" >= 2000 GROUP BY "fire_year"