5.14. SQL Select Group By¶
5.14.1. Group By¶
SELECT
firstname,
lastname,
agency
FROM astronauts
GROUP BY agency;
5.14.2. Having¶
SELECT
firstname,
lastname,
agency,
COUNT(id) as headcount
FROM astronauts
GROUP BY agency
HAVING COUNT(headcount) > 5;
5.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;