Tell me the chip model which has screen mode greater than 2.0 ? And also tell me the company name of that...
select chip_model, company_name from phone where screen_mode>2
Find the accreditation level that more than 3 phones use.
select accreditation_level from phone group by accreditation_level having count ( * ) > 3