New
ML System Design & SQL tracks just landed
See what's new
×
Question Bank
Pricing
Blog
Forum
HOT
JobRadar
NEW
Referral
Description
Solution
Discussion
Submissions
Ask AI
Question Bank
Snowflake
SQL Question
AI Insights
Quick Summary
Identify contacts with marketing activity spanning at least three consecutive calendar weeks.
Filter for contacts who also triggered at least one trial request event.
Return the matching contact email addresses.
What This Tests
Time-based grouping and interval normalization
Sequential pattern detection using row ordering
Gap analysis for consecutive periods
Condition intersection across multiple datasets
Common Patterns
Window Function
Deduplication
Date Arithmetic
Subquery
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
-
