odbtools/odbctest/mql/basic/49mix/0180subquery2.mql

select xid,xprom,zid,zprom.time('2024-01-02','2024-01-04').find(name='mtz').max().min().avg().sum().count() 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 xid="mtx:x5" and zid="mtz:z5"
/**
output()
**/
;