SQL exercises on movie Database: Find the titles of all movies that have no ratings

Last update on May 30 2022 07:23:17 (UTC/GMT +8 hours)

SQL movie Database: Subquery Exercise-7 with Solution

7. From the following table, write a SQL query to find those movies, which have no ratings. Return movie title.

Sample table: movie

Sample table: rating

Sample Solution:

SELECT DISTINCT mov_title 
FROM movie 
WHERE mov_id IN (
SELECT mov_id 
FROM movie 
WHERE mov_id NOT IN (
SELECT mov_id FROM Rating));

Sample Output:

                     mov_title
----------------------------------------------------
 Deliverance
 Amadeus
 Spirited Away
 The Prestige
 The Deer Hunter
 Eyes Wide Shut
 Back to the Future
 The Shawshank Redemption
 Seven Samurai
(9 rows)

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: From the following tables, write a SQL query to find those years, which produced at least one movie and that, received a rating of more than three stars. Sort the result-set in ascending order by movie year. Return movie year.
Next: From the following tables, write a SQL query to find those reviewers who have rated nothing for some movies. Return reviewer name.

SQL: Tips of the Day

SQL Server SELECT into existing table.

INSERT INTO dbo.TABLETWO SELECT col1, col2 FROM dbo.TABLEONE WHERE col3 LIKE @search_key

This assumes there's only two columns in dbo.TABLETWO - you need to specify the columns otherwise:

INSERT INTO dbo.TABLETWO (col1, col2) SELECT col1, col2 FROM dbo.TABLEONE WHERE col3 LIKE @search_key

Database: SQL Server

Ref: https://bit.ly/3y6tpA3