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

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