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)
CREATE TABLE phone (company_name CLOB, hardware_model_name CLOB, accreditation_type CLOB, accreditation_level CLOB, date CLOB, chip_model CLOB, screen_mode CLOB)

List the hardware model name for the phons that were produced by 'Nokia Corporation' but whose screen mode type is not Text.
SELECT DISTINCT T2.hardware_model_name FROM screen_mode AS T1 JOIN phone AS T2 ON T1.graphics_mode = T2.screen_mode WHERE t2.company_name = "Nokia Corporation" AND T1.type <> "Text"
SELECT DISTINCT "T2"."hardware_model_name" FROM "screen_mode" "T1" JOIN "phone" "T2" ON "T1"."graphics_mode" = "T2"."screen_mode" WHERE "Nokia Corporation" = "t2"."company_name" AND "T1"."type" <> "Text"