Tell me the ram size of the hardware model with name Nokia 700.
select t1.ram_mib from chip_model as t1 join phone as t2 on t1.model_name = t2.chip_model where t2.hardware_model_name = "Nokia 700"
How about for the GT-I9300?
select t1.ram_mib from chip_model as t1 join phone as t2 on t1.model_name = t2.chip_model where t2.hardware_model_name = "GT-I9300"
Tell me the average ram mib size of the chip models that are never used by any phone.
select avg(ram_mib) from chip_model where model_name not in (select chip_model from phone)