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

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