SQL: select accounts.name, SUM(transactions.credit) - SUM(transactions.debit) as total from `transactions` inner join `accounts` on `transactions`.`account_id` = `accounts`.`id` where `transactions`.`company_id` = ? and `accounts`.`type` = ? and `transactions`.`deleted_at` is null and 1 = 0 group by `accounts`.`id`, `accounts`.`name`
Bindings: [1,"revenue"]
[]