easy5 pts · first answer countswindow-functionssql

Each customer's first product bought

Which expression shows, on every order row, the product from that customer's first order?

A.LAST_VALUE(product) OVER (PARTITION BY customer_id ORDER BY order_date)B.FIRST_VALUE(product) OVER (PARTITION BY customer_id ORDER BY order_date)C.MIN(product) OVER (PARTITION BY customer_id)D.LAG(product) OVER (PARTITION BY customer_id ORDER BY order_date)

Discussion 0

Join free to post in the discussion.

Each customer's first product bought

Discussion 0

Related questions