Top 50 CTEs Interview Questions
The most frequently asked CTEs questions across all roles and companies, ranked by real interview frequency. Updated daily.
Standardize missing observation fields with fallback values, missingness flags, and ordered output.
Eversource Energy
Cincinnati Children's Hospital
Adtalem Global EducationUse CTEs, joins, and date logic to compare 30-day activity rates across monthly signup cohorts.
Gappify
Docusign
JioMeasure monthly user retention by signup cohort using date calculations and aggregated activity.
Google
LeidosCConstellation TechnologiesUse CTEs, joins, and month-based aggregation to calculate cohort retention over time from signup and activity data.
Workday
Amazon Development Center U.S.
The Sparks FoundationRank Goodyear product categories by regional revenue and preserve ties for the top position.
Identify the five most active users in each category using aggregation and row numbering.
Nestl S.ACCity of HopeEEulidiaUse joins, CTEs, and conditional aggregation to compare 30-day revenue and order counts before vs after each product launch.
Motive
Blue Orange Digital
QuoraRewrite a slow PostgreSQL loan payment query to reduce scanned rows while preserving the required aggregated results.
Biz2Credit
AmeripriseEEltro Cyberchrome PrivateSign up to see every question
Create a free account to unlock this list and practice real interview questions.