Ordering by multiple criteria
You're interested in exploring the film catalog to surface fresh recommendations to film fans. You want to give independent films that have a lower-budget a chance to stand out. When budgets are similar, newer releases should appear higher in the list to highlight the most recent additions.
Toto cvičení je součástí kurzu
Intermediate SQL Querying with AI
Pokyny k cvičení
- Write a prompt to list film titles, years, and budgets, sorted by budget (lowest first) and then by release year (latest 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 title
FROM films;