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 average ram mib size of the chip models that are never used by any phone
assistant
SELECT AVG ( RAM_MiB ) FROM chip_model WHERE model_name NOT IN ( SELECT chip_model FROM phone );
human
How many chips is that which are never used by any phone?
assistant
SELECT COUNT( * ) FROM chip_model WHERE model_name NOT IN ( SELECT chip_model FROM phone );
human
Give me all their model names and ram mib
assistant
SELECT Model_name , RAM_MiB FROM chip_model WHERE model_name NOT IN ( SELECT chip_model FROM phone );
human
How many chips used by phones have a ram mib higher or equal to 64
assistant
SELECT COUNT( * ) FROM chip_model WHERE model_name IN ( SELECT chip_model FROM phone ) AND RAM_MiB > = 64 ;