University:
California State University, Northridge
Course:
IS 441 | Database Management Systems
Academic year:

2023
Views:

64

Pages:

1
Author:

Alicia W.

Answer this question : 1. Make SQL Query to show film that have the same category as the film “Jumanji Blade” and “Kane Exorcist” WITH target_categories AS ( SELECT c.category_id FROM film f LEFT JOIN film_category fc ON f.film_id = fc.film_id LEFT JOIN category c ON c.category_id = fc.category_id WHERE f.title IN ('Jumanji Blade', 'Kane Exorcist') ) SELECT f.title FROM film f LEFT JOIN film_category fc ON f.film_id = fc.film_id LEFT JOIN category c ON c.category_id = fc.category_id WHERE c.category_id IN (SELECT category_id FROM target_categories) ORDER BY 1 ASC; The output :