w3resource
SQL exercises

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. Write a query in SQL to return the name of all reviewers and name of 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)

Practice Online


Movie database model

Query Visualization:

Duration:

Query visualization of Find the name of all reviewers and movies together in a single list - Duration

Rows:

Query visualization of Find the name of all reviewers and movies together in a single list - Rows

Cost:

Query visualization of Find the name of all reviewers and movies together in a single list - Cost

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

Previous: Write a query in SQL to find the movies which was released before 1998.
Next: Write a query in SQL to find the name of all reviewers who have rated 7 or more stars to their rating.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming