Instruction Write a query to return the title of the film with the minimum duration. A movie's duration can be found using the length column. If there are ties, e.g., two movies have the same length, return either one of them.

Question 25

Shortest film

Unsolved Easy Lecture

Instruction

Write a query to return the title of the film with the minimum duration.
A movie's duration can be found using the length column.
If there are ties, e.g., two movies have the same length, return either one of them.

Table: film

film

film_id	title	description	release_year	language_id	original_language_id	rental_duration	rental_rate	length	replacement_cost	rating	last_update
1	ACADEMY DINOSAUR	A Epic Drama of a Feminist And a Mad Scientist who must Battle a Teacher in The Canadian Rockies	2006	1	NULL	6	0.99	86	20.99	PG	2017-09-10 17:46:03.905795-07
2	ACE GOLDFINGER	A Astounding Epistle of a Database Administrator And a Explorer who must Find a Car in Ancient China	2006	1	NULL	3	4.99	48	12.99	G	2017-09-10 17:46:03.905795-07

       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
--------------
 SHORT FILM

Solution

postgres

SELECT title
FROM film
ORDER BY length
LIMIT 1;

Explanation

This query selects the title of a movie from the "film" table in a Postgres database. It orders the results by the length of the movie (in minutes) in ascending order. It then limits the output to just one result, which will be the movie with the shortest length.

Last Submission

postgres

No submission yet for this engine. Run and submit your query to save it here.

Expected results

Submit a query to compare against expected output.

Engine Postgres

Interview timer

Recommended interview pacing

Easy: 5 min for direct warm-up style questions.

Medium: 10 min for multi-step interview queries.

Hard: 15 min for layered questions with tighter time pressure.

A common bar is solving about 2 medium-or-harder questions in a 30 minute interview.

5:00

Timer

Your results

Run your query to preview results here.

More IN, BETWEEN, LIKE, CASE WHEN Questions

Browse Topic Set

Question	Level	Company	FTPR
#178. Members who worked at both Microsoft and Google	Medium	linkedin	34%
#177. Purchases by platform report	Medium	amazon	10%
#176. Employees' annual bonus	Easy	amazon	12%
#160. Sellers with no sales by day	Hard	ebay	11%
#156. Cancellation rate by unbanned users	Hard	lyft	15%
#155. Driver with the highest cancellation rate	Easy	lyft	24%
#151. Salary report	Easy	dropbox	18%
#138. Happy restaurants	Easy	doordash	14%
#136. Extremely late orders	Easy	doordash	11%
#131. Churned accounts	Hard	affirm	10%
#102. Histogram by visit session duration	Hard	google	17%
#35. Film length report	Easy		27%
#34. Stocked up movies	Easy		27%
#33. Returning customers	Medium		8%
#32. Unpopular movies	Hard		17%
#31. Movies that have not been returned	Easy		26%
#30. Inactive customers in May	Easy		22%
#29. Second highest spend customer	Medium		14%
#28. Film with the second largest cast	Medium		26%
#27. Film with the largest cast	Easy		27%
#26. Second shortest film	Easy		30%
#24. Films with more than 10 actors	Medium		19%
#22. Average cost per rental transaction	Easy		42%
#15. Fast movie watchers vs slow watchers	Hard		6%