Skip to content
Advertisement

count case with multiple conditions in same row

I need to export data of status from s.status column like

I expect it to be counted in one row but instead I am getting smthing like this

https://i.stack.imgur.com/K4wyc.png

Can anyone help me write it so I can get the data in one row ?

Thank you

Advertisement

Answer

Remove s.status from your group by

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement