Identify favorite actors for Spain
You're now going to explore actor popularity in Spain. Use as alias the first letter of the table, except for the table actsin use ai instead.
Deze oefening maakt deel uit van de cursus
Data-Driven Decision Making in SQL
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
SELECT *
FROM renting as r
LEFT JOIN ___ -- Augment table renting with information about customers
___
LEFT JOIN ___ -- Augment the table renting with the table actsin
___
LEFT JOIN ___ -- Augment table renting with information about actors
___;