New
ML System Design & SQL tracks just landed
See what's new
×
Question Bank
Pricing
Blog
Forum
HOT
Referral
Description
Solution
Discussion
Submissions
Ask AI
Question Bank
SQL Question
AI Insights
Quick Summary
Filter posts created within a rolling 7-day window.
Calculate reaction counts per post, ensuring posts with zero interactions still count.
Compute and round the mean reaction count grouped by user relationship status.
What This Tests
Date range filtering
Outer join semantics for preserving null/zero records
Nested aggregation patterns
Rounding and sorting grouped results
Common Patterns
Left Join
Aggregation
Date Arithmetic
Groupby
Collapse
Hint 1
Hint 2
What Interviewers May Ask Next
Accepted
23
/104
Acceptance Rate
22.1%
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
-
