How can you solve in Spark SQL this case when issue?

[UserBird]

Case

when

A= 'B' or 'C' or 'D' then 'E'

A = 'F' or 'G' ..... or 'Z' then 'F'

A = 'G' then ‘H'

else 'NA' end as test

You can use both IF or Case when statement, but provide me with the best solution. Thank you!

[Clément_Stenac]

We already replied here https://answers.dataiku.com/1545/case-when-with-multiple-cases-like