List the hardware model name for the phones that were produced by "Nokia Corporation".
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"
For these phones, which ones have screen model 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"
How about the ones that do not?
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"