Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ACTOR (actor_id, first_name, last_name, last_update) LANGUAGE (language_id, name, last_update) CATEGORY (category_id, name, last_update) FILM (film_id, title, description, release_year, language_id, length, rating, last_update) FILM_ACTOR(actor_id, film_id, last_update)
ACTOR (actor_id, first_name, last_name, last_update)
LANGUAGE (language_id, name, last_update)
CATEGORY (category_id, name, last_update)
FILM (film_id, title, description, release_year, language_id, length, rating, last_update)
FILM_ACTOR(actor_id, film_id, last_update)
FILM_CATEGORY (film_id, category_id, last_update)
COMMENTS (review_id, film_id, reviewer_name, comment, score, last_update)
Write the following queries in MYSQL, using the schema provided above.
Question - Find the reviewers that have reviewed movies in all the categories.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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 Started