SELECT * FROM npath (
ON aggregate_clicks
PARTITION BY sessionid
ORDER BY clicktime
MODE (nonoverlapping)
PATTERN ('A*.C+.A*')
SYMBOLS (productprice > 200 AND
pagetype='checkout' AS C, true AS A)
RESULT (FIRST(sessionid OF A) AS sessionid,
ACCUMULATE (pagetype OF ANY(A,C)) AS path,
AVG (productprice OF ANY(A,C)) AS sum)
) ORDER BY sessionid;