1. Learn
  2. /
  3. Courses
  4. /
  5. Data-Driven Decision Making in SQL

Exercise

Actors in comedies

In order to analyze the diversity of actors in comedies, first, report a list of actors who play in comedies and then, the number of actors for each nationality playing in comedies.

Instructions 1/4

undefined XP
    1
    2
    3
    4
  • Select the records from the table actsin of all actors who play in a Comedy. Use the first letter of the table as an alias.