Company SQL Question
High-Value Customer Orders (Top Order per Customer)
Practice this Amazon style SQL interview question with live execution and instant feedback.
Problem Statement
Find each customer's top 2 highest-value orders using a CTE and window function.
Relevant Tables
orderscustomers
SQL Concepts Used in This Question
Strengthen your understanding with these targeted learning topics: