Exercise: 22

For each value of PC speed that exceeds 600 MHz, find out the average price of PCs with identical speeds.

Result set: speed, average price.

Solution

SELECT speed, AVG(price)
FROM pc
GROUP BY speed
HAVING speed > 600