New
Dark mode is now available across the site
See what's new
×
Question Bank
Pricing
Blog
Forum
HOT
JobRadar
Description
Solution
Discussion
Submissions
Ask AI
Question Bank
Google
SQL Question
AI Insights
Quick Summary
Filter events to a 30-day window anchored at the most recent activity date.
Aggregate distinct suggestion counts per company and type across shown, clicked, and completed states.
Calculate conversion rates with explicit division-by-zero handling.
What This Tests
Dynamic date range filtering using aggregate anchors
Conditional aggregation for funnel metrics
Distinct counting within grouped contexts
Rate calculation and edge-case handling
Common Patterns
Subquery
Aggregation
Groupby
Date Arithmetic
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.6-Flash
0/2000
Run
Submit
Test Cases
SQL Schema
Pandas Schema
Input
-
Output
-
Expected
-
