SQL, Case When returning the incorrect results : <p>This error is starting to tick me off so im posting pictures instead sorry......</p>

<p><a href="https://i.stack.imgur.com/4ShQU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4ShQU.png" alt="enter image description here"></a></p>

<p><a href="https://i.stack.imgur.com/Kcu7S.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Kcu7S.png" alt="enter image description here"></a></p>
