SQLPad
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