As far as I understood, your requirement is to use more than one condition in case when. I have tested on my account and I was able to observe that we can use multiple boolean statements with CASE WHEN. Therefore, as far as I know, the query that you mentioned must be working fine without any troubles. I would like to know more details about your issue. Is it that the query is failing with any error? If yes, please share the error message. Else, what boolean statements you would like to convert into CASE WHEN?
These links - might probably be helpful:
If you require in depth analysis and help with respect to this issue then I would suggest you to raise a support case with AWS premium support team.
Is there a way to Connect a raspberry pi to a aws react app?asked a month ago
Embedding a Quicksight into a WIKI PageAccepted Answerasked 4 months ago
How can I format a decimal (DOUBLE) number in a select statement?asked 10 months ago
How to find dependent contact flows in AWS Connect that is utilizing a specific feature ?asked a month ago
IoT Events convert number to string for SNS custom payloadAccepted Answerasked 15 days ago
I'm trying to find a way to convert two booleans into a case when expressionAccepted Answerasked 15 days ago
DMS - Is it possible to write an expression to get a row as JSON?Accepted Answerasked 3 months ago
How long a call waited in queue?asked 4 years ago
Do I need to create two kinesis delivery streams to send messages under two different paths in the same s3 bucket?asked 4 months ago
Is there a way to add a step between other steps in a recipe with the UI?asked 2 years ago