Under pressure
Are there some tracks that have never been bought? Let's find out.
For the moment, let's find out which tracks have been bought at least once.
Deze oefening maakt deel uit van de cursus
Introduction to Oracle SQL
Oefeninstructies
- Find the tracks that appear in the
Tracktable, that also appear in theInvoiceLineone.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Get track IDs that appear in InvoiceLine
SELECT TrackId
FROM ___
___
SELECT TrackId
FROM ___