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
Can you list the maximum number of used kb in screen mode?
assistant
SELECT MAX( used_kb ) FROM screen_mode;
human
How about the minimum too?
assistant
SELECT MIN( used_kb ) FROM screen_mode;
human
Could you get me the average as well, please?
assistant
SELECT AVG ( used_kb ) FROM screen_mode ;