Need your help.
I have a table with some data on it. Please find attached a sample look of the table.
What i really want to do is, % of escalated cases by team.
Escalation % per team = Number of Escalations for the day / Number of cases handled for the day.
I cannot run pivot queries in my SQL as it doesnt support.
requesting your help to find the desired result in a query.