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 large is the ROM? | What do you mean by ROM? | When the 'Nokia Corporation' company produces phones, what is the average ROM size implemented into a certain phone.
assistant
SELECT T1.ROM_MiB FROM chip_model AS T1 JOIN phone AS T2 ON T1.Model_name = T2.chip_model WHERE T2.Company_name = 'Nokia Corporation' ORDER by T1.ROM_MiB desc LIMIT 1;
human
What is the smallest ROM size of any phone made by company Nokia?
assistant
SELECT T1.ROM_MiB FROM chip_model AS T1 JOIN phone AS T2 ON T1.Model_name = T2.chip_model WHERE T2.Company_name = "Nokia Corporation" ORDER by T1.ROM_MiB LIMIT 1 ;