Posted - 11/26/2012 : 05:01:24
I'm a bit stuck on this one...can anyone help please?
I've got a table (DW_Client) with a couple of status fields (Approved, Rejected), and a date field(CMDate). PK for each client is (C_UID)
I need to write a query that counts how many Clients were approved and rejected in each month, and the total number of Approvals submitted (Approval requests may cross the month boundary, so it's expected that Approved+Rejected won't total the number of requests)
| Month | Approved | Rejected | Total Requested |
| Jan | 21 | 3 | 42 |
| Feb | 20 | 6 | 28 |
| Mar | 12 | 1 | 19 |
and so on....