Correlated Subquery for Latest Order
Hard
subqueries
PayPal
Capital One
JPMorgan
Write a query using a correlated subquery to find each customer's most recent order. Return customer_id, order_id, and order_date, ordered by customer_id.
Expected Output: The latest order for each customer.
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...