The catalog team wants to find tracks that have never appeared in any customer purchase, as candidates for promotion or delisting. Using a correlated NOT EXISTS subquery against InvoiceLine, return every track with zero sales.
Return TrackId and Name, ordered by TrackId ascending.
| Column | Type |
|---|---|
| TrackId | INTEGER (Primary Key) |
| Name | TEXT |
| Column | Type |
|---|---|
| InvoiceLineId | INTEGER (Primary Key) |
| TrackId | INTEGER (Foreign Key -> Track.TrackId) |
Ready to take your skills to the next level? Enroll in our comprehensive Data Analyst Career Track to master SQL, Python, Excel, and Power BI.
Run your code to see the result here.