Coding task · SQL and MySQL course · Module 11: Capstone project
Active readers - HAVING
Filter whole groups, not single rows - that is what HAVING is for.
Task
Write a query that groups the rows of the wypozyczenia table by czytelnik_id and shows czytelnik_id and the number of loans as liczba, but ONLY for readers with more than 2 loans. Use GROUP BY and HAVING.