List names of each manufacturer?
select name from manufacturers
Name of each manufacturer's product?
select t1.name, t2.name from products as t1 join manufacturers as t2 on t1.manufacturer = t2.code
Price of each manufacturer's product?
select t1.price from products as t1 join manufacturers as t2 on t1.manufacturer = t2.code
Which product is the most expensive?
select name from products order by price desc limit 1
Name of each manufacturer along with the name and price of its most expensive product?
select t1.name, max ( t1.price ), t2.name from products as t1 join manufacturers as t2 on t1.manufacturer = t2.code group by t2.name
What of their least expensive product?
select t1.name, min ( t1.price ), t2.name from products as t1 join manufacturers as t2 on t1.manufacturer = t2.code group by t2.name