SELECT * FROM npath (
ON aggregate_clicks
PARTITION BY sessionid
ORDER BY clicktime
MODE (nonoverlapping)
PATTERN ('H+.D*.C{3,6}.D')
SYMBOLS (pagetype = 'home' AS H, pagetype='checkout' AS C,
pagetype <>'home' AND pagetype <>'checkout' AS D)
RESULT (FIRST(sessionid OF C) AS sessionid,
max_choose (productprice, productname OF C) AS
most_expensive_product,
MAX (productprice OF C) AS max_price,
min_choose (productprice, productname of C) AS
least_expensive_product,
MIN (productprice OF C) AS min_price)
) ORDER BY sessionid;