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
Airbnb
SQL Question
AI Insights
Quick Summary
Calculate total vacant days per listing by summing all availability windows.
Compute the average of those per-listing totals across all unique listings.
Handle empty datasets gracefully and round the final result to two decimal places.
What This Tests
Two-level aggregation patterns
Date span calculations excluding boundaries
Aggregate function behavior on empty inputs
Numerical precision and rounding control
Common Patterns
Aggregation
Date Arithmetic
Groupby
Collapse
Hint 1
Hint 2
What Interviewers May Ask Next
Accepted
25
/80
Acceptance Rate
31.3%
Ask AI Assistant
Ask AI Assistant
Ask me anything about this coding question!
Qwen
Qwen3.7-Flash
0/2000
Run
Submit
Test Cases
SQL Schema
Pandas Schema
Input
-
Output
-
Expected
-
