Tell me the the name of the phone model launched in the year 2003.
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 = 2003
How about that 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
I want to know the one with highest RAM size.
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 order by t1.ram_mib desc limit 1;