Another one bites the dust
Following up on our track purchase analysis, let's get the tracks that have never been bought.
Diese Übung ist Teil des Kurses
Introduction to Oracle SQL
Anleitung zur Übung
- Find the tracks that appear in the
Track
table, that don't appear in theInvoiceLine
one.
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
-- Get track IDs that don't appear in invoiceline
SELECT ___
FROM ___
___
SELECT ___
FROM ___