Another one bites the dust
Following up on our track purchase analysis, let's get the tracks that have never been bought.
This exercise is part of the course
Introduction to Oracle SQL
Exercise instructions
- Find the tracks that appear in the
Tracktable, that don't appear in theInvoiceLineone.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Get track IDs that don't appear in invoiceline
SELECT ___
FROM ___
___
SELECT ___
FROM ___