Answered step by step
Verified Expert Solution
Question
1 Approved Answer
People have the following ER model Movies have the following ER model Aliases for movies have the following ER model Which actors/actresses played only in
People have the following ER model Movies have the following ER model Aliases for movies have the following ER model Which actors/actresses played only in movies that rated 8.5 or higher? Task Write a SELECT statement that returns their names. Notes - Only consider movies where the actor/actress was a principal actor or actress - The actor/actress must have been a principal actor or actress in at least 3 movies (no one-hit wonders) - Every movie they were a principal actor or actress in has a rating of 8.5 Sample output name Elijah wood (1 row)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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 Started