What is the hardware model name for the phones 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"
What are the pixels of those?
select distinct t1.pixels 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"
What are the char cells of those?
select distinct t1.char_cells 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"
What are the used kb of those?
select distinct t1.used_kb 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"