What is the average price of all products?
select avg ( price ) from products
And what is the average price for each company?
select avg ( price ), manufacturer from products group by manufacturer
What are all companies names?
select name from manufacturers
And what are their headquarters?
select name, headquarter from manufacturers