Your SQL query has a syntax error in the CASE expression — specifically in this line:

WHEN IN ('Value1', 'Value2') THEN 'Result1 or 2'

WHEN IN (...) is not valid syntax in SQL. You cannot use IN directly after WHEN.

Instead, you must use:

WHEN Description IN ('Value1', 'Value2') THEN ...