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

Identify Horror Film Fans

MySQL
For each film in the Horror category with a PG-13 rating, find the first customer who rented the film. 
The result must be table with two columns  title and  first_customer - customer's name and surname name separated by space, ordered by film title
Expected result Columns: 2 · Rows: 13
title first_customer

Sample rows open after wrong checks: 0 of 3

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