Exercise: 15

Get hard drive capacities that are identical for two or more PCs. Result set: hd.

Solution

SELECT hd
FROM pc
GROUP BY hd
HAVING COUNT(*) >= 2