Mistakes against query processing order

eSymphony wants to find out what composers don't have songs shorter than 1,000,000 milliseconds, and this only for tracks where the genre id equals 1.

You have received a query from someone that tried to solve this problem. They don't have the query processing order knowledge that you do and have made some mistakes. You are kind enough to help them out.

Instructions

100 XP

Adapt the query that was given to you to make it run without errors.

Take Hint (-30 XP)