odbtools/odbctest/mql/uino/076.subquery.and.mql

SELECT  ID,name,totalaum,balance FROM /cq_post_demo/qx qx WHERE qx.name in ('合川') 
AND totalaum.time('2025-10-01 00:00:00','2025-10-31 23:59:59').find(name = 'cl').unit('avg', '1M').assert($1 > 0) 
AND balance.time('2025-10-01 00:00:00','2025-10-31 23:59:59').find(name = 'cl').unit('avg', '1M').assert($1 > 0) 
/**
output()
**/
;



SELECT  ID,name,totalaum.time('2025-10-01 00:00:00','2025-10-31 23:59:59').find(name = 'cl').unit('avg', '1M')
,balance.time('2025-10-01 00:00:00','2025-10-31 23:59:59').find(name = 'cl').unit('avg', '1M') FROM /cq_post_demo/qx qx WHERE qx.name in ('合川','永川') 
/**
output()
**/
;

SELECT  ID,name,totalaum,monthlyavgbalance FROM /cq_post_demo/qx qx WHERE qx.name in ('永川') 
AND totalaum.time('2025-10-01 00:00:00','2025-10-31 23:59:59').find(name = 'cl').unit('avg', '1M').assert($1 > 0) 
AND monthlyavgbalance.time('2025-10-01 00:00:00','2025-10-31 23:59:59').find(name = 'cl').unit('avg', '1M').assert($1 > 0)
/**
output()
**/
;