🙏 We need your help! SQLtest.online has no ads and lives only on donations. Even a small amount helps. Donate now →
SQL code copied to buffer
Task 23:

Sort Movies by Multiple Fields

MySQL
Select the title, rental rate and length of films from the film table.
Sort the resulting list in descending order of rental rate, films with the same rate sort by length of the film in ascending order
Expected result Columns: 3 · Rows: 1000
title rental_rate length

Sample rows open after wrong checks: 0 of 2

Write your query below and click "Check it!". Tables are described in the right pane.

Tutorial

By checking a query, you agree that it is stored without your account details and may be included in anonymized datasets, including for AI training. Learn more

The query result will appear here. Ctrl+Enter - Run query