3. Top 5 shortest movies

easy

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.



More SELECT, WHERE, AND, OR, ORDER BY, LIMIT questions

ID Title Level FTPR
212 Top issuing bank by category visa hard -
211 High spenders by issuer visa easy -
210 Issuer and merchant report visa easy -
200 Last week's absent students snap medium -
175 Employees' email account amazon easy
11%
152 Salary analysis dropbox easy
23%
126 Top 3 restaurants uber hard
9%
111 Second most popular product amazon medium
14%
92 Acceptance rate first week of 2021 spotify easy
14%
17 GROUCHO WILLIAMS’ actor_id easy
65%
16 Staff who live in Woodridge easy
72%
4 Staff without a profile image easy
67%
2 Top 3 movie categories by sales easy
47%
1 Top store for movie sales easy
30%