IMHO, this question does not really illustrate "the point that a subquery cannot be terminated with a semicolon". Semicolons terminate the statements and since the subquery is not the whole statement, it is rather obvious that it cannot be terminated. This question rather falls into a nasty category of those questions where the readers are suggested to use, as Hugo once aptly put it, "psychic powers" to figure out whether the author of the question meant to introduce a simple syntax error or such error is simply a result of an oversight.

Oleg