Income from movies
How much income did each movie generate? To answer this question subsequent SELECT statements can be used.
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 ___, -- Use a join to get the movie title and price for each movie rental
___
FROM renting AS r
LEFT JOIN ___ AS m
ON ___;