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
Pinterest
SQL Question
AI Insights
Quick Summary
Identify policy holders who have made three or more support calls.
Aggregate call volumes grouped by policy holder ID.
Count the total number of policy holders meeting the frequency threshold.
What This Tests
Grouping data by a categorical column
Aggregating row counts using aggregate functions
Filtering aggregated groups based on conditions
Counting rows resulting from a filtered aggregation
Common Patterns
Aggregation
HAVING Filter
Subquery
Groupby
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
-
