medium10 pts · first answer countssqlwindow-functions

Latest order per customer

Which approach returns only the most recent order for each customer?

A.SELECT * FROM orders ORDER BY order_date DESC LIMIT 1;B.Use ROW_NUMBER() OVER (PARTITION BY customer_id ORDER BY order_date DESC) and keep rows where it equals 1C.SELECT DISTINCT customer_id, order_date FROM orders;D.SELECT customer_id, MAX(order_id) FROM orders;

← Testing 20 metrics at once Overall rate flips when split →