Question 3
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
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.
Last Submission
postgresNo submission yet for this engine. Run and submit your query to save it here.
Submit a query to compare against expected output.
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
Run your query to preview results here.