Interview Guides
You are given transaction data and customer reference data from an internal analytics environment such as McKinsey's Wave. Write a PostgreSQL query that returns each valid customer's transactions in chronological order along with a running total of transaction amounts over time. The running total should restart for each customer, and transactions tied on the same date should be ordered by transaction ID so the cumulative values are deterministic. Exclude transactions that do not map to a known customer.
