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)

Average date of year that fire was discovered from 2000~2004?
SELECT AVG(discovery_date) FROM fires WHERE fire_year BETWEEN 2000 AND 2004
SELECT AVG("discovery_date") FROM "fires" WHERE "fire_year" <= 2004 AND "fire_year" >= 2000