Another one bites the dust
Following up on our track purchase analysis, let's get the tracks that have never been bought.
Este exercício faz parte do curso
Introduction to Oracle SQL
Instruções do exercício
- Find the tracks that appear in the
Track
table, that don't appear in theInvoiceLine
one.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
-- Get track IDs that don't appear in invoiceline
SELECT ___
FROM ___
___
SELECT ___
FROM ___