Can you show the Name of the Products of Code 1?
select name from products where code = 1
Can you show the Price of the Product Code 1?
select price from products where code = 1
Can you show the number of different products that are produced by companies at different headquarter cities?
select count ( distinct t1.name ), t2.headquarter from products as t1 join manufacturers as t2 on t1.manufacturer = t2.code group by t2.headquarter