6.14. SQL Select Group By
6.14.1. Group By
SELECT
firstname,
lastname,
agency
FROM astronauts
GROUP BY agency;
6.14.2. Having
SELECT
firstname,
lastname,
agency,
COUNT(id) as headcount
FROM astronauts
GROUP BY agency
HAVING COUNT(headcount) > 5;
6.14.3. Use Case - 0x01
SELECT
message,
level,
COUNT(level) AS count
FROM logs
WHERE
(datetime <= '1969-07-18' OR datetime >= '1969-07-20')
AND message LIKE 'Max__%'
AND level IN (
SELECT DISTINCT(level) FROM logs
)
GROUP BY level
HAVING count > 5
ORDER BY datetime DESC
LIMIT 5;