SQL exercises on movie Database: Find the name of all reviewers and movies together in a single list

SQL movie Database: Basic Exercise-5 with Solution

5. From the following tables, write a SQL query to find the name of all reviewers and movies together in a single list.

Sample table: movie

Sample table: reviewer

Sample Solution:

SELECT reviewer.rev_name
FROM reviewer
UNION
(SELECT movie.mov_title
FROM movie);

Sample Output:

                      rev_name
----------------------------------------------------

 Hannah Steele
 Annie Hall
 The Usual Suspects
 Aliens
 Wesley S. Walker
 Josh Cates
 Trainspotting
 Brandt Sponseller
 Eyes Wide Shut
 American Beauty
 Blade Runner
 The Shawshank Redemption
 Victor Woeltjen
 Simon Wright
 Righty Sock
 Princess Mononoke
 Jack Malvern
 Paul Monks
 Scott LeBrun
 Vertigo
 Beyond the Sea
 Chinatown
 The Prestige
 The Deer Hunter
 Sasha Goldshtein
 Back to the Future
 Good Will Hunting
 Seven Samurai
 Alec Shaw
 Boogie Nights
 Mike Salvati
 Krug Stillo
 Deliverance
 Braveheart
 The Innocents
 Spirited Away
 Lawrence of Arabia
 Vincent Cadena
 Donnie Darko
 Avatar
 Neal Wruck
 Slumdog Millionaire
 Amadeus
 Flagrant Baronessa
 Richard Adams
 Titanic
(47 rows)

Relational Algebra Expression:

Relational Algebra Tree:

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 table, write a SQL query to find those movies, which was released before 1998. Return movie title.
Next: From the following tables, write a SQL query to find all reviewers who have rated 7 or more stars to their rating. Return reviewer name.