When the "Nokia Corporation" company produces phones, what is the average ROM size implemented into a certain phone.
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
What is the smallest ROM size of any phone made by company Nokia?
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
What is the average ROM size of a phone made by company Nokia?
select avg ( 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"