New
ML System Design & SQL tracks just landed
See what's new
×
Question Bank
Pricing
Blog
Forum
HOT
JobRadar
NEW
Referral
Description
Solution
Discussion
Submissions
Ask AI
Question Bank
SQL Question
AI Insights
Quick Summary
Link each transaction record to its corresponding device model payout rate.
Aggregate the payout amounts for every unique store location.
Rank stores by their total accumulated payouts from highest to lowest.
What This Tests
Multi-table data joining
Conditional aggregation
Result set sorting
Handling referential integrity
Common Patterns
Inner Join
Aggregation
Groupby
Sort
Collapse
Hint 1
Hint 2
What Interviewers May Ask Next
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
-
