https://abundantcode.com/case-expression-in-a-query-in-sql-server/
CASE expression in a Query in SQL Server