A company has 3 zones, each zone has a specific number of customers. I have a task to count the number of customers on 2 dates: 1/1/2023 and 31/10/2023 for different zones.

Below is the raw data
| Customer_ID (number)| Zone |Process_date (number) |Amount
| ——– | ————|———— |
| 123 | Z1 |20221231 |3
| 325 | Z2 |20231031 |2
| 123 | Z1 |20221231 |1
| 635 | Z3 |20221231 |1
Expected result
|Zone |Number of customer on 1/1/2023 |Number of customer on 1/1/2023
| ————|———— |
| Z1 |2 |0
| Z2 |0 |1
| Z3 |1 |0