Still getting a syntax error near the keyword 'CASE'

Thanks for the help