New
The Learning module is now live
See what's new
×
Question Bank
Learning
NEW
Pricing
Blog
Forum
HOT
JobRadar
Description
Solution
Discussion
Submissions
Ask AI
Question Bank
SQL Question
AI Insights
Quick Summary
Group transactions by customer to isolate individual spending histories.
Calculate the maximum purchase amount for each customer group.
Sort the resulting records by purchase amount in descending order.
What This Tests
Aggregation using GROUP BY
Using aggregate functions like MAX
Sorting query results
Data summarization techniques
Common Patterns
Aggregation
Sort
Collapse
Hint 1
Hint 2
What Interviewers May Ask Next
Accepted
8
/9
Acceptance Rate
88.9%
Ask AI Assistant
Ask AI Assistant
Ask me anything about this coding question!
Qwen
Qwen3.6-Flash
0/2000
Run
Submit
Test Cases
SQL Schema
Pandas Schema
Input
-
Output
-
Expected
-
