🙏 We need your help! SQLtest.online has no ads and lives only on donations. Even a small amount helps. Donate now →
SQL code copied to buffer
Task 120:

Most Active Customers

MySQL
Find clients occupying the top three places by the number of films rented.

Please note: several clients may have the same number of films rented.

Display a table with columns: last_name, first_name, cnt (the number taken in film rental). Sort the results by the number of movies you rented in descending order, and then by last name.
Expected result Columns: 3 · Rows: 4
last_name first_name cnt

Write your query below and click "Check it!". Tables are described in the right pane.

Tutorial

By checking a query, you agree that it is stored without your account details and may be included in anonymized datasets, including for AI training. Learn more

The query result will appear here. Ctrl+Enter - Run query