SQL exercises on movie Database: Find the year when the movie American Beauty released
SQL movie Database: Basic Exercise-2 with Solution
2. Write a query in SQL to find the year when the movie American Beauty released.
Sample table: movie
SELECT mov_year FROM movie WHERE mov_title='American Beauty';
mov_year ---------- 1999 (1 row)
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
What is the difficulty level of this exercise?