Hello,
I suggest a new conditionnal function, very common in other languages : case when
https://www.w3schools.com/sql/sql_case.asp
Advantages :
-in some cases, more readable
-faster
-standard
Best regards
Bi Consultant (Dataviz & Dataprep) @ Business & Decision