Query the Top Ten Customers by Recent Spend
Company: Visa
Role: Software Engineer I
Category: Data Manipulation (SQL/Python)
Difficulty: medium
Interview Round: Online Assessment
Overview: Write one PostgreSQL query that ranks the ten users with the greatest completed-order spend in a fixed 30-day half-open window. Join users, orders, and line items, aggregate quantity times charged unit price, and break equal totals by user ID.
Read the full Visa Software Engineer I interview experience this question came from