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.