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.
This exercise is part of the course
Introduction to Oracle SQL
Exercise instructions
- Find the tracks that appear in the
Tracktable, that also appear in theInvoiceLineone.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Get track IDs that appear in InvoiceLine
SELECT TrackId
FROM ___
___
SELECT TrackId
FROM ___