select id,name,
  balance.time('2025-10-01 00:00:00','2025-10-02 23:59:59')
from /cq_post_demo/qx where name in ('永川','合川')
/**
output()
**/
;


SELECT qx.name , qx.balance  
FROM /cq_post_demo/qx qx 
WHERE balance.time('2025-10-01 00:00:00','2025-10-02 23:59:59').find(name = 'cl').unit('sum', '1d').assert($1 > 0)
/**
output()
**/
;

select id,name,
  balance.time('2025-10-01 00:00:00','2025-10-02 23:59:59').find(name='cl').unit('sum', '1d')
from /cq_post_demo/qx where name in ('永川','合川')
/**
output()
**/
;