Finding Actors by Favorite Movie Genre
 

Given three tables - playground.movies, playground.starring_actors, and playground.actor_ages - identify actors from the most common movie genre in your library. Assume each actor is listed once representing their best role. The task is to list actors with their age, sorted from oldest to youngest, who star in movies of your favorite genre (the most common genre in your list). In case of actors being the same age, sort them by name.The resultant table should have two columns, actor and age.

These are the tables to query for this question:
playground.movies
  • movie string
  • genre string
playground.starring_actors
  • id int
  • movie_name string
  • actor string
playground.actor_ages
  • actor string
  • age int
Your answer should include these columns:
  • actor varchar
  • age integer

Querying is only for logged in users!

Write Your Query Here (you can run selections by highlighting!)

Query Results

No queries have been run yet.