Yes, I think that must have been the aspect that I ran out of time on. The reason I included the CTE that reverses the order was so that rows like that would always be numbered 1. What I didn't work out was how not to include items that were completed as well. I'm going to leave it to you to work out how to get over the line. I'm guessing you're not too familiar with syntax like this, so it'll be a good opportunity for you to understand how it all works. It'll be you supporting the code, after all. Good luck!
John
Haha
Thanks John, appreciate the help.
I will pull my hair out figuring out that part but always up for learning something new.
As long as you are 100% it's possible.