easy5 pts · first answer countswindow-functionssql

What LEAD returns

Which expression puts the date of each customer's next order on the current row?

A.LAG(order_date) OVER (PARTITION BY customer_id ORDER BY order_date)B.MAX(order_date) OVER (PARTITION BY customer_id)C.FIRST_VALUE(order_date) OVER (PARTITION BY customer_id ORDER BY order_date)D.LEAD(order_date) OVER (PARTITION BY customer_id ORDER BY order_date)

Discussion 0

Join free to post in the discussion.

What LEAD returns

Discussion 0

Related questions