Select from renting
Only some users give a rating after watching a movie. Sometimes it is interesting to explore only those movie rentals where a rating was provided.
Deze oefening maakt deel uit van de cursus
Data-Driven Decision Making in SQL
Oefeninstructies
- Select from table
rentingall movie rentals from 2018. - Filter only those records which have a movie rating.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
SELECT *
FROM renting
WHERE date_renting ___ '2018-01-01' ___ '2018-12-31' -- Renting in 2018
AND rating ___; -- Rating exists