Tell me the phones that were launched in the year 2002.
select t2.hardware_model_name from chip_model as t1 join phone as t2 on t1.model_name = t2.chip_model where t1.launch_year = 2002
What companies were they produced by?
select t2.company_name from chip_model as t1 join phone as t2 on t1.model_name = t2.chip_model where t1.launch_year = 2002
Give information about the company and hardware model name for phones that have RAM size greater than 32.
select t2.hardware_model_name, t2.company_name from chip_model as t1 join phone as t2 on t1.model_name = t2.chip_model where t1.ram_mib > 32;