SQL Queries in MySQL

This is using the Sakila Sample database which can download here: https://dev.mysql.com/doc/sakila/en/sakila-installation.html"

A query is to find a complete list of movies in which the actor has performed.

Hint: You will need to join the actors, movies, and roles tables, and only retain rows where the various IDs from the tables (actor ID, movie ID) match each other and the name or ID of your actor. Our solution's query joins 3 tables in the FROM clause and contains one condition in its WHERE clause.