I've come to use CTE's rather than subqueries, as in the last example, simply because it is easier for me to read from the top down than from inside out.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills