You have three tables in your relational database: Movie, Star, and RolePlayed.

If the goal is to retrieve the title and rating of each movie in which Meg Ryan played a role, what errors, if any, exist in the following SQL statement?

SELECT *

FROM RolePlayed

WHERE StarID=Meg Ryan;

Answer:

(1) Movie (2) Star Rating Stari Name Movie Title Year Birth M1 PG-13 St1 Tom Hanks 1956 Castaway St2 Meg Ran M2 You've Got Mail PG 1961 M3 City of Angels PG-13 ISt3 Nicolas Cage 1964 (3) RolePlayed MoyielD StarD characterName M1 St1 Chuck Noland St1 M2 Joe Fox M2 St2 Kathleen Kelly M3 St2 Maggie Rice IM3 S3 Seth