/* Origin (request): GET https://testtra.puntlandgov.org
   Query 11 - 2024-11-22 11:47:04 [195.78ms] */
select sum(`outstanding_balance`) as aggregate from `invoice` inner join `transaction` on `invoice`.`transaction_id` = `transaction`.`id` where `transaction`.`service_id` = 1 and `invoice`.`invoice_amount` <> 0.00 and `due_date` < '2024-11-22' and `invoice`.`deleted_at` is null;
/*==================================================*/
