(Solved) : Actor Actorid Firstname Lastname Lastupdate Language Languageid Name Lastupdate Category C Q44150270 . . .
● 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 providedabove.
Question – Find the reviewers that have reviewed movies in allthe categories.
Expert Answer
Answer to ● ACTOR (actor_id, first_name, last_name, last_update) ● LANGUAGE (language_id, name, last_update) ● CATEGORY (cat…
OR