I thought ';' is a typo and ignored that.
Who uses a ';' anyway? it's not yet standard practice and if you do, you should realise that it would cause problems in the middle of a statement.
I need to buy some glasses now... I thought the trick was with the subquery referencing the main table with an alias, which is more informative. Suppose, I need to buy some glasses now...