Another one bites the dust
Following up on our track purchase analysis, let's get the tracks that have never been bought.
Latihan ini adalah bagian dari kursus
Introduction to Oracle SQL
Petunjuk latihan
- Find the tracks that appear in the
Tracktable, that don't appear in theInvoiceLineone.
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
-- Get track IDs that don't appear in invoiceline
SELECT ___
FROM ___
___
SELECT ___
FROM ___