odbtools/odbctest/mql/basic/49mix/0190subquery3.mql

-- bucket filter 作为条件
-- select xid,xprom,zid,zprom.time('2024-01-02','2024-01-04').find(name='mtz').max().min().avg().sum().count().groupby("name") from (
-- match (x:mtx) -[:mtx_mtz]-> (z:mtz)
-- return x.id as xid, z.id as zid, x.xprom as xprom, z.zprom as zprom
-- ) where zid="mtz:z5" and xprom.time('2024-01-02','2024-01-04').find(name='mtz').max().assert($1=240.24)
-- /**
-- output()
-- match("xprom.0.2",240.24,"zprom.0.3",143.143,"zprom.0.6",48.48,"zprom.0.9",95.95381249999997~95.9538125,"zprom.0.12",9211.565999999997~9211.566,"zprom.0.15",96)
-- **/
-- ;