Put in order · SQL and MySQL course · Module 11: Capstone project

Readers with more than two loans

Arrange the clauses of the query with HAVING in the correct order (top to bottom):

Items to put in order

  • SELECT czytelnik_id, COUNT(*) AS liczba
  • HAVING COUNT(*) > 2;
  • FROM wypozyczenia
  • GROUP BY czytelnik_id

You can check the correct answer by solving this task in the CodeWorlds game.