🙏 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 32:

Rented Films

MySQL
Generate a list of films rented by customer GEORGE LINTON. Display the title and rating for each rented film.
Sort the list by ratings in next order: 'R' appear first, followed by 'G', 'NC-17', 'PG-13' and 'PG' last. Within each rating group, sort by title. 
Expected result Columns: 2 · Rows: 30
title rating

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