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
Filter the dataset to a 30-day window anchored at the most recent conversion date.
Calculate the average conversion value per unique user for each campaign.
Rank campaigns by this metric descending and limit to the top three results.
What This Tests
Time-window filtering using relative date boundaries
Group-level aggregation with distinct entity counting
Custom sorting and row-limiting logic
Handling edge cases like empty partitions or division by zero
Common Patterns
Date Arithmetic
Aggregation
Groupby
Subquery
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
-
