Hi! Could we please enable some services and cookies to improve your experience and our website?
Privacy & Cookie Policy.Find customers who rented the movie 'FRONTIER CABIN'. Write a query that returns a table with columns first_name, last_name and email and rental_date sorted in ascending order by the dates in the last column
Use MySQL syntax to write your answer. Descriptions of tables are provided in the right pane.
Write your request in the field below and click the "Check it!" button.ER diagram of the Sakila database
The Sakila database contains 15 main tables describing various aspects of a DVD rental company.
actor_id | first_name | last_name | last_update |
---|---|---|---|
1 | John | Doe | 2023-01-01 12:00:00 |
address_id | address | address2 | district | city_id | postal_code | phone | last_update |
---|---|---|---|---|---|---|---|
1 | 123 Main St | [null] | Downtown | 1 | 12345 | +1234567890 | 2023-01-01 12:00:00 |
category_id | name | last_update |
---|---|---|
1 | Action | 2023-01-01 12:00:00 |
city_id | city | country_id | last_update |
---|---|---|---|
1 | Metropolis | 1 | 2023-01-01 12:00:00 |
country_id | country | last_update |
---|---|---|
1 | United States | 2023-01-01 12:00:00 |
customer_id | store_id | first_name | last_name | address_id | active | create_date | last_update | |
---|---|---|---|---|---|---|---|---|
1 | 1 | John | Doe | john.doe@example.com | 1 | 1 | 2023-01-01 12:00:00 | 2023-01-01 12:00:00 |
film_id | title | description | release_year | language_id | original_language_id | rental_duration | rental_rate | length | replacement_cost | rating | special_features | last_update |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Film Title | A brief description of the film. | 2000 | 1 | 2 | 5 | 4.99 | 120 | 19.99 | PG-13 | Trailers, Commentaries | 2023-01-01 12:00:00 |
actor_id | film_id | last_update |
---|---|---|
1 | 1 | 2023-01-01 12:00:00 |
film_id | category_id | last_update |
---|---|---|
1 | 1 | 2023-01-01 12:00:00 |
inventory_id | film_id | store_id | last_update |
---|---|---|---|
1 | 23 | 2 | 2023-01-01 12:00:00 |
language_id | name | last_update |
---|---|---|
1 | English | 2023-01-01 12:00:00 |
payment_id | customer_id | staff_id | rental_id | amount | payment_date | last_update |
---|---|---|---|---|---|---|
1 | 1 | 1 | 1 | 4.99 | 2023-01-01 12:13:14 | 2023-01-01 12:14:15 |
rental_id | rental_date | inventory_id | customer_id | return_date | staff_id | last_update |
---|---|---|---|---|---|---|
1 | 2023-01-01 16:15:21 | 1 | 1 | 2023-01-10 09:12:36 | 1 | 2023-01-01 12:00:00 |
staff_id | first_name | last_name | address_id | picture | store_id | active | username | password | last_update | |
---|---|---|---|---|---|---|---|---|---|---|
1 | John | Doe | 1 | [null] | john.doe@example.com | 1 | 1 | johndoe | ******** | 2023-01-01 12:00:00 |
store_id | manager_staff_id | address_id | last_update |
---|---|---|---|
1 | 1 | 1 | 2023-01-01 12:00:00 |