Write a query in SQL to find the list of all those movies with year which include the words Boogie Nights. [An editor is available at the bottom of the page to write and execute the scripts. Write a query in SQL to return the reviewer name, movie title, and number of stars for those movies which rating is the lowest one. Write a query in SQL to find the titles of all movies that have no ratings. Write a query in SQL to find the name of all reviewers who have rated 7 or more stars to their rating. Go to the editor, 8. Write a query in SQL to find the titles of all movies directed by James Cameron. ], 1. [An editor is available at the bottom of the page to write and execute the scripts. Write a query in SQL to find the movie title, year, date of release, director and actor for those movies which reviewer is unknown. Write a query in SQL to find the movie which was released in the year 1999. Go to the editor, 2. The test database to be used in the mandatory exercises is a version of the Internet Movie Database (imdb), which is a large database containing information on approximately 700000 films and 60000 TV series, 1.7 million persons related to the films, descriptions of the films etc. 2. Dataset (in our SQL folder): imdb-cs3200.zip In this project you are asked to write several SQL queries on a relational movie database. Write a query in SQL to find all the years which produced at least one movie and that received a rating of more than 3 stars. Go to the editor, 8. (using subquery) Go to the editor, 3. Write a query in SQL to find the movie title, and the highest number of stars that movie received and arranged the result according to the group of a movie and the movie title appear alphabetically in ascending order. Sample table: movie. Write a query in SQL to return the name of all reviewers and name of movies together in a single list. Go to the editor, Query visualizations are generated using Postgres Explain Visualizer (pev). Write a query in SQL to find the names of all reviewers who rated the movie American Beauty. Go to the editor, 12. select Title from Movie m inner join (select top 20 MovieID,sum(Rating) Rate from Ratings group by movieid having count(UserID)>39 order by sum(Rating) DESC) tblon m.MovieID=tbl.MovieIDorder by tbl.Rate desc. Write a query in SQL to return the reviewer name, movie title, and stars for those movies which reviewed by a reviewer and must be rated. This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License. Write a query in SQL to find the name and year of the movies. Do not submit any solution of the above exercises at here, if you want to contribute go to the appropriate exercise page. select m. mov_title, m. mov_year, g. gen_title, d. dir_fname, d. dir_lname Write a query in SQL to find the name of the director (first and last names) who directed a movie that casted a role for 'Eyes Wide Shut'. Go to the editor, 10. IN MYSQL. Write a query in SQL to find the ID number for the actor whose first name is 'Woody' and the last name is 'Allen'. Go to the editor, Query visualizations are generated using Postgres Explain Visualizer (pev). Write a query in SQL to find the name of those movies where one or more actors acted in two or more movies. Go to the editor, 10. Go to the editor, 6. 1. Click me to see the solution. Go to the editor, 4. Write a query in SQL to find the name and year of the movies. Go to the editor, 5. Go to the editor, 3. The ERD or database design of the sample movie database is here (open in new tab, or save, to see a larger version): This database stores information about movies, the cast and crew involved, where the movie was produced and by which company, and other information about movies such as the languages, genres, and keywords. Write a query in SQL to find the reviewer's name and the title of the movie for those reviewers who rated more than one movies. Go to the editor, 2. The database consists of six tables: ACTOR (id, fname, lname, gender) MOVIE (id, name, year) DIRECTORS (id, fname, lname) CASTS (pid, mid, role)