Instruction
- Write a query to return the titles of the 5 shortest movies by duration.
- The order of your results doesn't matter.
Table: film
col_name | col_type ----------------------+-------------------------- film_id | integer title | text description | text release_year | integer language_id | smallint original_language_id | smallint rental_duration | smallint rental_rate | numeric length | smallint replacement_cost | numeric rating | text
Sample results
title --------------------- MOVIE 1 MOVIE 2 MOVIE 3 MOVIE 4 MOVIE 5
Expected results
Solution postgres
SELECT title
FROM film
ORDER BY length
LIMIT 5;
Explanation
This query retrieves the names of the top 5 shortest films in a database table called "film". It does this by selecting the "title" column in the table and ordering the results by the "length" column (presumably the duration of the film). The "LIMIT 5" clause at the end ensures that only the top 5 results are returned.
Copied
Your results