Which films are most frequently rented?
Now that you've figured out the relationships between the tables and their columns, you are ready to answer the question we started with:
Which films are most frequently rented?
Use the relationship diagram to answer this question.
Cet exercice fait partie du cours
Applying SQL to Real-World Problems
Instructions
- Use the entity diagram above to correctly join the required tables to answer this question.
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de code.
SELECT title, COUNT(title)
FROM ___ AS f
INNER JOIN ___ AS i
ON f.___ = i.___
INNER JOIN ___ AS r
ON i.___ = r.___
GROUP BY title
ORDER BY count DESC;