Dispensary accounts with the most money open, excluding brand partners
select customer_name, round(sum(balance)) as open_balance, count(*) as invoices from v_invoices where balance > 0 and customer_name not ilike '%Kitchen Share%' group by all order by 2 desc limit 25