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

Movie Cast Lists

MySQL
Get the name of each movie from the movies table along with the list of actors.
The list of actors should consist of the actor's first and last name, separated by a space, separated by commas and sorted alphabetically. (As in this example: ELVIS MARX, SISSY SOBIESKI, VAL BOLGER).
The query result should contain two columns: title - the title of the movie and actors, ordered by the number of actors in descending order.
Expected result Columns: 2 · Rows: 997
title actors

Sample rows open after wrong checks: 0 of 2

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