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.
Bu egzersiz
Applying SQL to Real-World Problems
kursunun bir parçasıdırEgzersiz talimatları
- Use the entity diagram above to correctly join the required tables to answer this question.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
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;