CREATE TABLE phone (company_name CLOB, hardware_model_name CLOB, accreditation_type CLOB, accreditation_level CLOB, date CLOB, chip_model CLOB, screen_mode CLOB)
CREATE TABLE screen_mode (graphics_mode NUMBER, char_cells CLOB, pixels CLOB, hardware_colours NUMBER, used_kb NUMBER, map CLOB, type CLOB)
CREATE TABLE chip_model (model_name CLOB, launch_year NUMBER, ram_mib NUMBER, rom_mib NUMBER, slots CLOB, wifi CLOB, bluetooth CLOB)

the names of models that launched between 2002 and 2004.
SELECT model_name FROM chip_model WHERE launch_year BETWEEN 2002 AND 2004
SELECT "model_name" FROM "chip_model" WHERE "launch_year" <= 2004 AND "launch_year" >= 2002