โ† Citi questions

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.