Question: to write an SQL query using insert statement
I need to write an sql query for the below using InSERT command.pls help.
Insert 5-star ratings by James Cameron for all movies in the database. Leave the review date as NULL.
The table details are as follows:
Movie ( mID, title, year, director ) English: There is a movie with ID number mID, a title, a release year, and a director.
Reviewer ( rID, name ) English: The reviewer with ID number rID has a certain name.
Rating ( rID, mID, stars, ratingDate ) English: The reviewer rID gave the movie mID a number of stars rating (1-5) on a certain ratingDate.