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
List the name of the company that produces more than one phone model.
assistant
SELECT Company_name FROM phone GROUP BY Company_name HAVING COUNT( * ) > 1;
human
Hmmm. Please list the name of the company that produces only one phone model.
assistant
SELECT Company_name FROM phone GROUP BY Company_name HAVING COUNT( * ) = 1;
human
Ok. Can you show me the models produced by Nokia Corporation?
assistant
SELECT Hardware_Model_name FROM phone WHERE Company_name = "Nokia Corporation" ;