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 rows to a seven-day window anchored on the maximum date.
Aggregate view counts per post and identify those meeting a threshold.
Count qualifying posts while handling empty inputs gracefully.
What This Tests
Dynamic date range filtering
Grouping and aggregation
Threshold filtering with HAVING
Edge case handling for empty results
Common Patterns
Subquery
Aggregation
HAVING Filter
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.7-Flash
0/2000
Run
Submit
Test Cases
SQL Schema
Pandas Schema
Input
-
Output
-
Expected
-
