Queries for various analysis done within the first half of 2023
These queries are for the analysis below: DORMANT ACCOUNTS FREQUENCY OF CUSTOMER PAYMENTS - THIS ONE SUMMARISES FREQUENCY OF CUSTOMER PAYMENTS AT DIFFERENT SHOPPING POINTS; USED TO HIGHLIGHT WHERE A CUSTOMER SHOPS MORE, UNFUNDED ACCOUNTS, MPESA IMPACT ANALYSYS A: PRE AND POST WAIVER (BEFORE AND AFTER FEB 15 2023), MPESA IMPACT ANALYSYS A: PRE AND POST WAIVER (MOM IMPACT), CARDS ANALYSIS (CHECKS FOR CARDS TRANSACTION ACTIVITY BETWEEN NARADA AND WAY4 FOR UNIQUE CUSTOMER CARDS)