you join tables with wrong columns (you need to use GenreID, not Name)

SELECT 
    Track.Name AS TrackName, 
    Track.GenreId, 
    Track.Composer, 
    Genre.Name AS GenreName
FROM Track
INNER JOIN Genre ON Track.GenreId = Genre.GenreId
WHERE 
    Track.GenreId IN (1, 3, 4, 5, 23, 9)
ORDER BY Track.Name;