Nice work. When I was dealing with longer queries, WITH was my friend, too. Unfortunately, the architect didn’t let me use functions.

I like the SQL style you use. Readability is a virtue.