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"

**Sakila Schema

A query is to find a complete list of movies in which each actor has performed. Two columns, one for the name and one for the movies, all movies should be concatenated by a comma.

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.