write a query that produces a list of documentary movies (where the movie category is 'Documentary') and

Fantastic news! We've Found the answer you've been seeking!

Question:

write a query that produces a list of documentary movies (where the movie category is 'Documentary') and a movie description containing the word 'Drama'. You will need a triple join between category, film_category, and category tables.

SELECT c.Name AS CategoryName, f.title AS FilmTitle, f.description AS FilmDescription, f.release_year AS ReleaseYear FROM film f JOIN film_category fc ON f.film_id = fc.film_id JOIN category c ON fc.category_id = c.category_id WHERE c.name = 'Documentary' AND f.description LIKE '%drama%';