Company SQL Question

Customer Purchase Frequency

Practice this Amazon style SQL interview question with live execution and instant feedback.

Problem Statement

Find customers who have placed more than 1 order. Show customer name, email, total orders, and total amount spent. Order by total amount spent descending.

Relevant Tables

customersorders

SQL Concepts Used in This Question

Strengthen your understanding with these targeted learning topics:

INNER JOIN Deep DiveJoins & Relationships
Window Functions FundamentalsWindow Functions
COUNT, SUM, AVG, MIN, MAXAggregate Functions & Grouping