Exploring the table renting
The table renting includes all records of movie rentals. Each record has a unique ID renting_id
. It also contains information about customers (customer_id
) and which movies they watched (movie_id
). Furthermore, customers can give a rating after watching the movie, and the day the movie was rented is recorded.
This exercise is part of the course
Data-Driven Decision Making in SQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT ___ -- Select all
___; -- From table renting