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.
This exercise is part of the course
Data-Driven Decision Making in SQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT ___ -- Select the records from the table `actsin` of all actors who play in a Comedy
FROM actsin AS ai
___
___
WHERE ___ = 'Comedy';