In the below query, I'm trying to use a case statement to pull answers to questions submitted in a form that flows into separate rows of the table.
For example, the table is laid out as this:
complaint_ID,question,answer
1234,DOB,1/1/2020
1234,SSN,5678
1234,Mobile_Number,4255551212
What I...