Exercise: 18

Find the makers of the cheapest color printers.

Result set: maker, price.

Solution

SELECT DISTINCT product.maker, printer.price
FROM product
	RIGHT JOIN printer ON product.model = printer.model
WHERE printer.color = 'y'
	AND printer.price = (
		SELECT MIN(price)
		FROM printer
		WHERE color = 'y'
	)