w3resource
SQL exercises

SQL exercises on movie Database: Display the name and year of the movies

SQL movie Database: Basic Exercise-1 with Solution

1. Write a query in SQL to find the name and year of the movies.

Sample table: movie


Sample Solution:

SELECT mov_title, mov_year
FROM movie;

Sample Output:

                     mov_title                      | mov_year
----------------------------------------------------+----------
 Vertigo                                            |     1958
 The Innocents                                      |     1961
 Lawrence of Arabia                                 |     1962
 The Deer Hunter                                    |     1978
 Amadeus                                            |     1984
 Blade Runner                                       |     1982
 Eyes Wide Shut                                     |     1999
 The Usual Suspects                                 |     1995
 Chinatown                                          |     1974
 Boogie Nights                                      |     1997
 Annie Hall                                         |     1977
 Princess Mononoke                                  |     1997
 The Shawshank Redemption                           |     1994
 American Beauty                                    |     1999
 Titanic                                            |     1997
 Good Will Hunting                                  |     1997
 Deliverance                                        |     1972
 Trainspotting                                      |     1996
 The Prestige                                       |     2006
 Donnie Darko                                       |     2001
 Slumdog Millionaire                                |     2008
 Aliens                                             |     1986
 Beyond the Sea                                     |     2004
 Avatar                                             |     2009
 Seven Samurai                                      |     1954
 Spirited Away                                      |     2001
 Back to the Future                                 |     1985
 Braveheart                                         |     1995
(28 rows)

Practice Online


Movie database model

Query Visualization:

Duration:

Query visualization of Display the name and year of the movies - Duration

Rows:

Query visualization of Display the name and year of the movies - Rows

Cost:

Query visualization of Display the name and year of the movies - Cost

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

Previous: SQL BASIC exercises on movie Database
Next: Write a query in SQL to find the year when the movie American Beauty released.

What is the difficulty level of this exercise?



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