MySQL course, flawed example

Hi!

In the MySQL course I’ve found an example that doesn’t work, because the code is not correct, in my opinion. What Mosh used here is a subquery to provide a value to the main query, but the result of that subquery is a row, while it was supposed to be an ID.

msedge_1LTevQOuzW

This is how I’ve wrote the same code.

MySQLWorkbench_08nmzcMFmN

Is my assumption correct, or am I missing something? Thank you for your attention.