and what of the cheapest memory?
select price from products where name = 'Memory' order by price limit 1
Who is the manufacturer of the zip drive?
select manufacturer from products where name = 'ZIP drive'
And who manufactures the Hard drive?
select manufacturer from products where name = 'Hard drive'