🙏 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 51:

Most Diverse Actors

MySQL
Get a list of actors that starred in all films categories and the count of distinct films they have appeared in.
The result must contain first_name, last_name and film_count columns and should be ordered by the number of films in descending order and then by the actor's last name.

                    
Expected result Columns: 3 · Rows: 11
first_name last_name film_count

Sample rows open after wrong checks: 0 of 3

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