Thanks. I am learning CTE and so it was helpful when you broke it down, but how do you put all this in one query?:-)