Latest Transaction and Amount for Every Customer
Filed under Citi
The question
Given a table with columns customer_id, order_date, and order_amount (where a customer places at most one order per day), write a SQL query to retrieve the most recent transaction date along with the order amount for each customer.
No write-up yet. Related questions below have one.
Related Citi questions
Collected from public candidate posts and coding forums. Updated Nov 2026.