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
Filter the message log to a specific month and year.
Aggregate the total number of messages sent by each user.
Rank users by volume, break ties by ID, and return the top two.
What This Tests
Time-based data filtering
Group-level aggregation
Multi-criteria result sorting
Post-aggregation result limiting
Common Patterns
Aggregation
Groupby
Sort
Collapse
Hint
What Interviewers May Ask Next
Accepted
8
/12
Acceptance Rate
66.7%
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
-
