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.
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.