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
how many phones are presented on the table | Did you mean to ask for the number of entries in the table phone? | exactly
assistant
SELECT COUNT( * ) FROM phone;
human
list out the company name
assistant
SELECT Company_name FROM phone;
human
list the hardware model name
assistant
SELECT Hardware_Model_name FROM phone;
human
what is the chip model of XPERIA T, XPERIA J
assistant
SELECT chip_model FROM phone WHERE Hardware_Model_name = "XPERIA T, XPERIA J" ;