25. Shortest film

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_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

Expected results

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.

Your results

More IN, BETWEEN, LIKE, CASE WHEN questions

ID	Title	Level	FTPR
178	Members who worked at both Microsoft and Google linkedin	medium	36%
177	Purchases by platform report amazon	medium	9%
176	Employees' annual bonus amazon	easy	11%
160	Sellers with no sales by day ebay	hard	7%
156	Cancellation rate by unbanned users lyft	hard	14%
155	Driver with the highest cancellation rate lyft	easy	22%
151	Salary report dropbox	easy	16%
138	Happy restaurants doordash	easy	10%
136	Extremely late orders doordash	easy	5%
131	Churned accounts affirm	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	medium	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%
26	Second shortest film	easy	29%
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%

Single Table

Multi Table

Window Functions

Company

25. Shortest film

More IN, BETWEEN, LIKE, CASE WHEN questions