I pity any already confused developer who reads this article. As, despite the title, it isn't about sub-queries. What the author refers to are called Derived Tables, Table Expressions (which...
Overall I've rated this article poorly. Sorry, a "Top Twenty Tips" sounds good (a nice bit of alliteration), but unfortunately for a topic as complex as this you can only...