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.
This is how I’ve wrote the same code.
Is my assumption correct, or am I missing something? Thank you for your attention.