```
 -------------------------------------------  
|  CustomerID |    Action      |    Amount  |
|-------------------------------------------|
|   111       |     deposit    |      100   |
|   111       |    withdrawl   |       25   | 
|   222       |     deposit    |      500   |
|   222       |     deposit    |      100   |
|   333       |    withdrawl   |      100   |
|   333       |     deposit    |      100   |
 -------------------------------------------  

```

Write a query that for each `customerID` would display the total `Amount` for that customer, where Deposit Actions are added to the total and Withdrawls are substracted from total