Instruction

  • Write a query to return the title of the second shortest film based on its duration/length.
  • A movie's duration can be found using the length column.
  • If there are ties, return just one of them.

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
--------------
 SECOND SHORTEST


More IN, BETWEEN, LIKE, CASE WHEN questions

ID Title Level FTPR
178 Members who worked at both Microsoft and Google human resource medium
36%
177 Purchases by platform report ecommerce medium
9%
176 Employees' annual bonus human resource easy
11%
160 Sellers with no sales by day ecommerce hard
7%
156 Cancellation rate by unbanned users ride sharing hard
14%
155 Driver with the highest cancellation rate ride sharing easy
22%
151 Salary report human resource easy
16%
138 Happy restaurants food delivery easy
10%
136 Extremely late orders food delivery easy
5%
131 Churned accounts fintech hard
10%
102 Histogram by visit session duration mobile hard
12%
35 Film length report easy
26%
34 Stocked up movies easy
28%
33 Returning customers hard
8%
32 Unpopular movies hard
16%
31 Movies that have not been returned easy
27%
30 Inactive customers in May easy
21%
29 Second highest spend customer medium
16%
28 Film with the second largest cast medium
25%
27 Film with the largest cast easy
27%
25 Shortest film easy
46%
24 Films with more than 10 actors medium
20%
22 Average cost per rental transaction easy
43%
15 Fast movie watchers vs slow watchers hard
5%
14 Good days and bad days hard
4%
13 Actors' first name medium
13%
12 Actors' last name ending in 'EN' or 'RY' easy
30%
11 Actors' last name easy
24%