Excellent article Helen, pleased to see you also answered the why not use subqueries instead. I love using them as you mentioned in your post to keep things readable and reusable in the query.
Thanks Mark. They've been a hot topic around the office recently so thought they deserved a bit of love and a post to support my case.
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.