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
Identify all unique participants across both caller and recipient roles within a seven-day window anchored to the latest activity.
Count how many of these participants exceeded a threshold of ten calls during that period.
Calculate the participation-to-initiator percentage while safely handling empty datasets.
What This Tests
Date range filtering using window anchors
Set union operations for bidirectional relationships
Conditional aggregation and threshold filtering
Percentage calculation with division-by-zero protection
Handling edge cases like empty inputs
Common Patterns
Union
Aggregation
HAVING Filter
Left Join
Collapse
Hint 1
Hint 2
What Interviewers May Ask Next
Accepted
1
/1
Acceptance Rate
100.0%
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
-
