请参阅没有EXISTS的子查询 [ ^ ]并自行制定解决方案。

从上述评论中提示。

Refer to Subqueries with NOT EXISTS[^] and work out the solution yourself.
Take hint from the above comments.