Technical

Given invoice tables for multiple years, write a query to find the customers with the highest lifetime spend.

Business Intelligence Engineer

Amazon

Did you come across this question in an interview?

Your answer

Answers

Unlock Community Insights

Contribute your knowledge to access all answers

#Give&Take - Share to unlock

  • Given invoice tables for multiple years, write a query to find the customers with the highest lifetime spend.
  • How would you write a query to identify the top customers by lifetime spend from multi-year invoice data?
  • Can you pull out the customers who have spent the most over all time using yearly invoice tables?
  • Write an SQL query to find customers with the highest total invoice amounts across all years.
  • Given invoice records spanning multiple years, how would you identify the top-spending customers?
  • Suppose each year has its own invoice table — how would you find customers with the highest lifetime purchases?
  • Using invoice data from several years, how do you determine which customers have spent the most?
  • Write a query to find the top lifetime spenders from a dataset that includes multiple years of invoices.
  • How would you aggregate invoice data to find the highest-spending customers over time?
  • From multi-year invoice tables, write a query to show which customers have the greatest total spend.
  • What's your approach to identifying customers with the highest cumulative spending using historical invoice data?
Try Our AI Interviewer

Prepare for success with realistic, role-specific interview simulations.

Try AI Interview Now

Interview question asked to Business Intelligence Engineers interviewing at Amazon: Given invoice tables for multiple years, write a query to find the customers with the highest lifetime spend..