Sql query is showing as wrong even though the answer is correct

Question

The code i typed several times was correct but it still shows as incorrect

Answer 1

No one can help you if you don't provide any detail.

Is it from SoloLearn course?
If yes, which course, module name and lesson / exercise name?

To my understanding, sub-query is discussed in the intermediate course and you haven't join it yet.