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
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%';
Step by Step Solution
3.39 Rating (152 Votes )
There are 3 Steps involved in it
Step: 1
STEP BY STEP ANSWER As per the requirement submitted above kindly find the below solution SQL QUERY ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get StartedRecommended Textbook for
Concepts of Database Management
Authors: Philip J. Pratt, Mary Z. Last
8th edition
1285427106, 978-1285427102
Students also viewed these Databases questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App