SQL exercises on movie Database: Find the year when the movie American Beauty released
2. From the following table, write a SQL query to find when the movie 'American Beauty' released. Return movie release year.
Sample table: movie
mov_id | mov_title | mov_year | mov_time | mov_lang | mov_dt_rel | mov_rel_country
--------+----------------------------------------------------+----------+----------+-----------------+------------+-----------------
901 | Vertigo | 1958 | 128 | English | 1958-08-24 | UK
902 | The Innocents | 1961 | 100 | English | 1962-02-19 | SW
903 | Lawrence of Arabia | 1962 | 216 | English | 1962-12-11 | UK
904 | The Deer Hunter | 1978 | 183 | English | 1979-03-08 | UK
905 | Amadeus | 1984 | 160 | English | 1985-01-07 | UK
906 | Blade Runner | 1982 | 117 | English | 1982-09-09 | UK
907 | Eyes Wide Shut | 1999 | 159 | English | | UK
908 | The Usual Suspects | 1995 | 106 | English | 1995-08-25 | UK
909 | Chinatown | 1974 | 130 | English | 1974-08-09 | UK
910 | Boogie Nights | 1997 | 155 | English | 1998-02-16 | UK
......
925 | Braveheart | 1995 | 178 | English | 1995-09-08 | UK
Sample Solution:
-- Selecting the 'mov_year' column from the 'movie' table
-- Filtering rows where 'mov_title' is equal to 'American Beauty'
SELECT mov_year
FROM movie
WHERE mov_title = 'American Beauty';
Sample Output:
mov_year
----------
1999
(1 row)
Code Explanation:
The statement provided in SQL that selects the "mov_year" (release years of movie) column from the 'movie' table where the "mov_title" (movie titles) column has a value of 'American Beauty'.
Relational Algebra Expression:
Relational Algebra Tree:
Go to:
PREV : From the following table, write a SQL query to find the name and year of the movies. Return movie title, movie release year.
NEXT : From the following table, write a SQL query to find the movie, which was released in the year 1999. Return movie title.
Practice Online
Query Visualization:
Duration:
Rows:
Cost:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.