How do I make a case statement inside another case statement. I need to find when condition1 = 77, then column value = y only if the y value is equal to 3. otherwise the value should be condition3
I tried coding it like this:
CASE
WHEN confition1 LIKE '77'
THEN condition2
CASE
WHEN condition2 LIKE '3'
THEN condition2
ELSE condition3
ELSE condition3