SELECT * FROM NPATH ( ON trans1 PARTITION BY userid ORDER BY ts MODE (nonoverlapping) PATTERN ('A+') SYMBOLS(TRUE AS A) RESULT (FIRST(userid OF A) AS Userid, LAST_NOTNULL (gender OF A) AS Gender, MAX_CHOOSE (productamt, productname OF A) AS Max_prod, MIN_CHOOSE (productamt, productname OF A) AS Min_prod) ) ORDER BY 1;