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
Find the names of the chip models that are not used by any phone with full accreditation type.
assistant
SELECT model_name FROM chip_model EXCEPT SELECT chip_model FROM phone WHERE Accreditation_type = 'Full'
human
the names of models that launched between 2002 and 2004.
assistant
SELECT Model_name FROM chip_model WHERE Launch_year BETWEEN 2002 AND 2004;
human
How many phone hardware models are produced by the company named 'Nokia Corporation'?
assistant
SELECT count(*) FROM phone WHERE Company_name = 'Nokia Corporation';
human
List the name of the company that produced more than one phone model.
assistant
SELECT Company_name FROM phone GROUP BY Company_name HAVING count(*) > 1;
human
What are the wifi and screen mode type of the hardware model named 'LG-P760'?
assistant
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';
human
How many models do not have the wifi function?
assistant
SELECT COUNT( * ) FROM chip_model WHERE wifi = "No" ;