Exercise: 25

Find the printer makers also producing PCs with the lowest RAM capacity and the highest processor speed of all PCs having the lowest RAM capacity.

Result set: maker.

Solution

SELECT DISTINCT maker
FROM product
WHERE type = 'printer'
	AND maker IN (
		SELECT maker
		FROM product
			RIGHT JOIN pc ON product.model = pc.model
		WHERE ram = (
				SELECT MIN(ram)
				FROM pc
			)
			AND speed = (
				SELECT MAX(speed)
				FROM pc
				WHERE ram = (
					SELECT MIN(ram)
					FROM pc
				)
			)
	)