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.
Den här övningen är en del av kursen
Applying SQL to Real-World Problems
Övningsinstruktioner
- Use the entity diagram above to correctly join the required tables to answer this question.
Interaktiv övning med praktiskt arbete
Testa den här övningen genom att slutföra den här exempelkoden.
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;