Tell me the phone hardware model and company name for the phones whose screen usage in kb is larger than 10.
select distinct t2.hardware_model_name, t2.company_name from screen_mode as t1 join phone as t2 on t1.graphics_mode = t2.screen_mode where t1.used_kb > 10
Smaller than 15?
select distinct t2.hardware_model_name, t2.company_name from screen_mode as t1 join phone as t2 on t1.graphics_mode = t2.screen_mode where t1.used_kb < 15
Okay, now I want to know the phones with screen usage within that range.
select distinct t2.hardware_model_name, t2.company_name from screen_mode as t1 join phone as t2 on t1.graphics_mode = t2.screen_mode where t1.used_kb between 10 and 15