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 2000s and 1990s?
SELECT SUM(fire_size) FROM fires WHERE state = "TX" AND fire_year BETWEEN 2000 AND 2010 UNION SELECT SUM(fire_size) FROM fires WHERE state = "TX" AND fire_year BETWEEN 1990 AND 2000
SELECT SUM("fire_size") FROM "fires" WHERE "TX" = "state" AND "fire_year" <= 2010 AND "fire_year" >= 2000 UNION SELECT SUM("fire_size") FROM "fires" WHERE "TX" = "state" AND "fire_year" <= 2000 AND "fire_year" >= 1990