SQL exercises on movie Database: Find the titles of the movies with ID 905, 907, 917

Last update on January 12 2026 12:49:06 (UTC/GMT +8 hours)

8. From the following table, write a SQL query to find the movies with ID 905 or 907 or 917. Return movie title.

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

View the table

Sample Solution:

-- Selecting 'mov_title' from the 'movie' table
-- Filtering results where 'mov_id' is in the specified list (905, 907, 917)
SELECT mov_title
FROM movie
WHERE mov_id IN (905, 907, 917);

Sample Output:

                     mov_title
----------------------------------------------------
 Amadeus
 Eyes Wide Shut
 Deliverance
(3 rows)

Code Explanation:

The said query in SQL which selects the "mov_title" column from the 'movie' table for movies with the specified IDs (905, 907, 917).
The "WHERE" clause filters the results to only include rows where "mov_id" is one of the specified values (905, 907, or 917).

Relational Algebra Expression: