SQL code copied to buffer
RU PT FR
Task 98:

Find actors duets

Find acting duos who have appeared together in more than five films.
Output the result as a table with columns: 
    - actor_id, first_name, last_name - identifier, first and last name of the first actor, 
    - actor_id, first_name, last_name - identifier, first and last name of the second actor,
    - films_together - the number of films in which they starred together.

In each line, we first display the actor with the last name higher in alphabetical order. Sort the results in descending order of number of collaborations, then by the last name of the first actor.

Use MariaDB syntax to write your answer. Descriptions of tables are provided in the right pane.

Write your request in the field below and click the "Check it!" button.
Get hint
Copy code Clear editor

Hi! Could we please enable some services and cookies to improve your experience and our website?

Privacy & Cookie Policy.