Sql-ex Solutions

Exercise: 19

For each maker having models in the Laptop table, find out the average screen size of the laptops he produces.

Result set: maker, average screen size.

Solution

SELECT maker, AVG(screen)
FROM (
	SELECT product.maker, laptop.screen
	FROM product
		JOIN laptop ON product.model = laptop.model
) AS p
GROUP BY p.maker