Tell the name of the company which produced the phone Nokia 700.
select company_name from phone where hardware_model_name = "Nokia 700"
So what is the company which produced the phone LG-P760?
select company_name from phone where hardware_model_name = "LG-P760"
Tell me the name of the company that produced more than one phone model.
select company_name from phone group by company_name having count(*) > 1;