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
Meta
SQL Question
AI Insights
Quick Summary
Categorize daily ad impressions into peak and off-peak periods based on their occurrence timestamps.
Calculate key performance metrics including conversion rates, revenue per impression, and average conversion latency.
Maintain consistent denominators across metrics while gracefully handling periods with zero conversions.
What This Tests
Conditional time-based categorization
Preserving unmatched records via outer joins
Conditional aggregation for selective averaging
Edge case handling for zero-count groupings
Consistent metric derivation within grouped results
Common Patterns
Left Join
Aggregation
Date Arithmetic
Groupby
Collapse
Hint 1
Hint 2
Hint 3
What Interviewers May Ask Next
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
-
