Untitled

select
customers.name
,customers.lastname
,(select sum(cash.value) from cash where cash.customerid =32822 
and cash.time<1701425254) as customer_balance
--,coalesce (tariffs.value,liabilities.value) as coal
,string_agg(distinct coalesce (tariffs.value,liabilities.value)::text, ', ')  as coal2

from customers customers
left join cash cash on customers.id=cash.customerid 
left join assignments assignments on customers.id =assignments.customerid 
left join liabilities liabilities on liabilities.id=assignments.liabilityid
left join tariffs tariffs on tariffs.id=assignments.tariffid 
where 
customers.id =32822 
and cash.time<1701425254
group by customers.name, customers.lastname, customer_balance