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 sessions that share any time interval with at least one other session.
Count how many distinct sessions overlap with each qualifying session.
Filter out non-overlapping sessions and sort results by overlap count descending.
What This Tests
Comparing time intervals for concurrency using strict inequalities
Pairing records against themselves to find relationships
Grouping and counting related records
Filtering groups by aggregate conditions
Common Patterns
Self Join
Aggregation
HAVING Filter
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
-
