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 fires were more than 100 acres in 2006?
SELECT COUNT(*) FROM fires WHERE fire_year = 2006 AND fire_size > 100
SELECT COUNT(*) FROM "fires" WHERE "fire_size" > 100 AND "fire_year" = 2006