SQL , usage of case

also the last question… I think I just need an answer. I have spent too much time on this .
Would like to learn and move on.

I am gonna go for a run now, later come back and tackle this little issue!
:facepunch: