Page History

use dataverse tpch;

for $d in dataset Lineitem
/*+ psort */

order by $d.l_extendedprice

return $d

use dataverse tpch;

for $d in dataset Lineitem

for $t in dataset Orders
/*+ psort */

where 4 * $d.l_extendedprice - $t.o_totalprice > -2 and 4 * $d.l_extendedprice - $t.o_totalprice < 2

return

{"ok": $d

.l_orderkey, "ln": $d.l_linenumber, "ep": $l.l_extendedprice, "tp": $t.o_totalprice}