SELECT * FROM npath ( ON aggregate_clicks PARTITION BY sessionid ORDER BY clicktime MODE (nonoverlapping) PATTERN('H+.D*.C{3,}.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;