w3resource
SQL exercises

SQL exercises on movie Database: Find the list of those movies with year which include the words Boogie Nights

SQL movie Database: Basic Exercise-9 with Solution

9. Write a query in SQL to find the list of all those movies with year which include the words Boogie Nights.

Sample table: movie


Sample Solution:

SELECT mov_id, mov_title, mov_year
FROM movie
WHERE mov_title LIKE '%Boogie%Nights%'
ORDER BY mov_year ASC;

Sample Output:

 mov_id |                     mov_title                      | mov_year
--------+----------------------------------------------------+----------
    910 | Boogie Nights                                      |     1997
(1 row)

Practice Online


Movie database model

Query Visualization:

Duration:

Query visualization of Find the list of those movies with year which include the words Boogie Nights - Duration

Rows:

Query visualization of Find the list of those movies with year which include the words Boogie Nights - Rows

Cost:

Query visualization of Find the list of those movies with year which include the words Boogie Nights - Cost

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

Previous: Write a query in SQL to find the titles of the movies with ID 905, 907, 917.
Next: Write a query in SQL to find the ID number for the actor whose first name is 'Woody' and the last name is 'Allen'.

What is the difficulty level of this exercise?



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