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)

Sum of the acres burned in NC state in 2006?
SELECT SUM(fire_size) FROM fires WHERE state = "NY" AND fire_year = "2006"
SELECT SUM("fire_size") FROM "fires" WHERE "2006" = "fire_year" AND "NY" = "state"