I have a table which consists of list of transactions, I need to get the output as below
Customer name Status Count of Status
ABC Bank Success 10
ABC Bank Failures 5
XYZ Bank Success 5
Can someone provide me the query ? and let me know if you need any more details.