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
Join event logs with ad metadata to calculate performance metrics.
Filter events using a dynamic 30-day window anchored to the latest activity date.
Compute aggregate counts and a derived ratio while safely managing division by zero.
What This Tests
Dynamic date windowing relative to dataset extremes
Conditional aggregation across categorical values
Safe division handling for derived metrics
Multi-table joins with proper cardinality management
Common Patterns
Inner Join
Aggregation
Subquery
Date Arithmetic
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.7-Flash
0/2000
Run
Submit
Test Cases
SQL Schema
Pandas Schema
Input
-
Output
-
Expected
-
