Tell me the hardware model name for the phones that have screen mode type "Graphics".
select distinct t2.hardware_model_name from screen_mode as t1 join phone as t2 on t1.graphics_mode = t2.screen_mode where t1.type = "Graphics"
So how about the phones that have screen model type "Text"?
select distinct t2.hardware_model_name from screen_mode as t1 join phone as t2 on t1.graphics_mode = t2.screen_mode where t1.type = "Text"
Okay, for now I want to know the hardware model name for the phones that were produced by "Nokia Corporation" or whose screen mode type is "Graphics."
select distinct t2.hardware_model_name from screen_mode as t1 join phone as t2 on t1.graphics_mode = t2.screen_mode where t1.type = "Graphics" or t2.company_name = "Nokia Corporation"