EXCEPT: Genres Without Tracks

Use EXCEPT to find genres that exist but have no tracks associated with them. EXCEPT returns rows from the first query that aren't in the second.

Write a query using EXCEPT to find genres with no tracks.

Note: In the Chinook database, all current genres have at least one track, so an empty result set (0 rows) is the expected correct output.

Schema: Genre

Schema: Track

Requirements:

• First query: All genre names
• Second query: Genre names that have tracks
• EXCEPT gives genres without any tracks
• Return genre Name only

EXCEPT Syntax:

SELECT column FROM table1
EXCEPT
SELECT column FROM table2;