New
ML System Design & SQL tracks just landed
See what's new
×
Question Bank
Pricing
Blog
Forum
HOT
Referral
Description
Solution
Discussion
Submissions
Ask AI
Question Bank
SQL Question
AI Insights
Quick Summary
Join three tables to connect events with user demographics and pin classifications.
Filter for US-based users who signed up fewer than 30 days prior to each event date.
Conditionally count impressions and clicks, then calculate a safely rounded click-through rate per date and format.
What This Tests
Multi-table joins and row-level filtering
Conditional aggregation for metric counting
Date arithmetic to define cohort boundaries
Safe division and numerical precision handling
Common Patterns
Multiple Joins
Aggregation
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.6-Flash
0/2000
Run
Submit
Test Cases
SQL Schema
Pandas Schema
Input
-
Output
-
Expected
-
