human
Schema:
chip_model (Model_name, Launch_year, RAM_MiB, ROM_MiB, Slots, WiFi, Bluetooth)
screen_mode (Graphics_mode, Char_cells, Pixels, Hardware_colours, used_kb, map, Type)
phone (Company_name, Hardware_Model_name, Accreditation_type, Accreditation_level, Date, chip_model, screen_mode)
Please answer with SQL.
assistant
Sure, I understand.
human
Tell me the chip model which has screen mode greater than 2.0 ? And also tell me the company name of that...
assistant
SELECT chip_model , Company_name FROM phone WHERE screen_mode > 2;
human
Find the accreditation level that more than 3 phones use.
assistant
SELECT Accreditation_level FROM phone GROUP BY Accreditation_level HAVING COUNT( * ) > 3 ;