Top 50 Date Functions Interview Questions
The most frequently asked Date Functions questions across all roles and companies, ranked by real interview frequency. Updated daily.
Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.
Meta
Spotify
Meta ITUse CTEs, joins, and date filtering to calculate 30-day retention by signup cohort from login and feature usage data.
Curefit
Indeed
TikTokCalculate each user's running order total over time using a window function.
Bayer
Sparksoft
Western DigitalAggregate user activity by week, then use LAG to compare sessions and watch time versus the prior active week.
B Lab Global
Tapad
ScaleCalculate month-1 retention for January vs February signup cohorts using joins, date filtering, and aggregation.
Trideum
Zulily
eBayCalculate weekly retention by signup cohort using CTEs, joins, date truncation, and distinct user counts.
Brex
Postman
eToroSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Use joins, conditional aggregation, and date filtering to measure Carvana location performance over the last 30 days.
Carvana
Georgetown University
PluralsightUse joins, a CTE, and aggregation to rank the top 5 products by non-returned revenue in the last 30 days.
Blue Nile
O'Reilly Auto Parts
Cengage