Minimum and maximum
You're completing your executive report by adding duration ranges to provide full context for each year's content. After showing averages and totals, the minimum and maximum durations help executives understand the breadth of content available, whether a year offers diverse duration options or clusters around similar lengths.
Toto cvičení je součástí kurzu
Intermediate SQL Querying with AI
Pokyny k cvičení
- Create a prompt that shows, for each release year, the lowest and highest duration, and have the highest duration show first.
Interaktivní cvičení na vyzkoušení si v praxi
Vyzkoušejte si toto cvičení dokončením tohoto ukázkového kódu.
SELECT release_year
FROM films;