Steve Jones - SSC Editor (9/2/2015)

---

The sixth one should have had brackets. That's been corrected. However, I missed a few since there could be no joiner (=/AS) in there, so it's probably more like 12. The CTE thing is interesting. Not sure I think this is an alias, as it's really a column name specified for the position, not an alias, but it is debatable.

The subquery one is also interested.

I'll award back points later. This likely isn't a great question.