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

Exercise

Movies and actors

You are asked to give an overview of which actors play in which movie.

Instructions

100 XP
  • Create a list of actor names and movie titles in which they act. Make sure that each combination of actor and movie appears only once.
  • Use as an alias for the table actsin the two letters ai.