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.
Diese Übung ist Teil des Kurses
Introduction to Oracle SQL
Anleitung zur Übung
- Find the tracks that appear in the
Tracktable, that also appear in theInvoiceLineone.
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
-- Get track IDs that appear in InvoiceLine
SELECT TrackId
FROM ___
___
SELECT TrackId
FROM ___