Drill 29: Inputs and outputs — Aggregation and GROUP BY

SELECT course_slug,
       COUNT(*) AS total,
       ROUND(AVG(minutes), 1) AS avg_minutes,
       SUM(minutes) AS total_minutes
FROM lessons
WHERE level = 'Beginner'
GROUP BY course_slug
HAVING COUNT(*) >= 3
ORDER BY avg_minutes DESC;