Hi, I need a SQL query as below..
from Table a, table b
where updt_ts between TO_DATE('22-FEB-2018 00:00:00','DD-MON-YYYY HH24:MI:SS')
And To_Date('28-FEB-2018 23:59:59','DD-MON-YYYY HH24:MI:SS') and a.cust_id=b.cust_id
group by b.cust_id,b.cust_nm,a.status_cd;
I need to add a column which will filter how many 'pending' transaction from STATUS_CD column and add that column next to the count(status_cd). Please share your thoughts.