What are the wifi and screen mode type of the hardware model named "GT-I9300"?
select t1.wifi, t3.type from chip_model as t1 join phone as t2 on t1.model_name = t2.chip_model join screen_mode as t3 on t2.screen_mode = t3.graphics_mode where t2.hardware_model_name = "GT-I9300"
How about that of the hardware model named "Z520e"?
select t1.wifi, t3.type from chip_model as t1 join phone as t2 on t1.model_name = t2.chip_model join screen_mode as t3 on t2.screen_mode = t3.graphics_mode where t2.hardware_model_name = "Z520e"
Okay, I want to know that of the hardware model named "LG-P760".
select t1.wifi, t3.type from chip_model as t1 join phone as t2 on t1.model_name = t2.chip_model join screen_mode as t3 on t2.screen_mode = t3.graphics_mode where t2.hardware_model_name = "LG-P760"