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.
Este exercício faz parte do curso
Introduction to Oracle SQL
Instruções do exercício
- Find the tracks that appear in the
Tracktable, that also appear in theInvoiceLineone.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
-- Get track IDs that appear in InvoiceLine
SELECT TrackId
FROM ___
___
SELECT TrackId
FROM ___