Joins 2 - "Peliculas"

--Ej 1
SELECT genres.name AS 'Genero', movies.title AS 'Titulo'
FROM movies INNER JOIN genres ON movies.genre_id=genres.id;
--Ej 2
SELECT movies.title, genres.name AS 'genre', CONCAT(actors.first_name, ' ', actors.last_name) AS 'actor'
FROM genres INNER JOIN movies ON genres.id=movies.genre_id
                INNER JOIN actor_movie ON movies.id=actor_movie.movie_id
                INNER JOIN actors ON actor_movie.actor_id=actors.id;
--Ej 3
SELECT actors.first_name, movies.title
FROM actors INNER JOIN actor_movie ON actors.id=actor_movie.actor_id
                INNER JOIN movies ON actor_movie.movie_id=movies.id
ORDER BY actors.first_name;
--Ej 4.0
SELECT movies.title, genres.name
FROM movies LEFT JOIN genres ON movies.genre_id=genres.id;
--Ej 4.1
SELECT movies.title, genres.name
FROM movies LEFT JOIN genres ON movies.genre_id=genres.id
ORDER BY movies.title, genres.name;
--Ej 4.2
SELECT movies.title, genres.name
FROM movies LEFT JOIN genres ON movies.genre_id=genres.id
ORDER BY genres.name, movies.title;
--Ej 5
SELECT episodes.title AS 'episode', COUNT(seasons.id) AS 'season', series.title AS 'serie', genres.name AS 'genere', COUNT(actors.id) AS 'actors'
FROM episodes INNER JOIN seasons ON episodes.season_id=seasons.id
                  INNER JOIN series ON seasons.serie_id=series.id
                  INNER JOIN genres ON series.genre_id=genres.id
                  INNER JOIN actor_episode ON episodes.id=actor_episode.episode_id
                  INNER JOIN actors ON actor_episode.actor_id=actors.id
GROUP BY episodes.id;
--Ej 6
SELECT genres.name AS 'genre', movies.rating AS 'rating', movies.title AS 'movie'
FROM genres INNER JOIN movies ON genres.id=movies.genre_id
WHERE movies.rating>5;
--Ej 7
SELECT series.title AS 'serie', COUNT(episodes.id) AS 'episodes'
FROM series INNER JOIN seasons ON series.id=seasons.serie_id
                INNER JOIN episodes ON seasons.id=episodes.season_id
WHERE episodes.release_date LIKE '2016%';
--Ej 8
SELECT series.title AS 'serie', COUNT(episodes.id) AS 'episodes'
FROM series INNER JOIN seasons ON series.id=seasons.serie_id
                INNER JOIN episodes ON seasons.id=episodes.season_id
WHERE episodes.release_date LIKE '2020%';