This query is saying to select all users who do not already appear in the Review
table. We're going to take these users and we're going to select their uID
, then we are going to assign them the correct values for all of the Review
attributes. As a reminder, the Review
table has the attributes: uID
, mID
, Rating
, and ratingDate
. So in our query we are selecting their uID
, then having the rate the mID
of 109 (which is the movie Cinderella), they both are going to rate the movie with a 3, and we inserted a null
value for the ratingDate
. Lastly, we are going to take this end result, and INSERT INTO
the Review
table.