Top 50 CTEs Interview Questions
The most frequently asked CTEs questions across all roles and companies, ranked by real interview frequency. Updated daily.
Use CTEs, joins, and date logic to compare 30-day activity rates across monthly signup cohorts.
Gappify
Docusign
JioUse 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 FoundationUse CTEs, joins, and conditional aggregation to compare customer orders before and after a product launch.
Quora
Motive
IntuitUse a CTE and ROW_NUMBER to identify duplicate customer records, keep one row, and flag the rest.
MicrosoftMeasure monthly user retention by signup cohort using date calculations and aggregated activity.
LeidosCConstellation Technologies
CarGurusSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Use joins, CTEs, and conditional aggregation to compare 30-day revenue and order counts before vs after each product launch.
Motive
Blue Orange DigitalQuoraUse CTEs, LEFT JOINs, aggregation, and LAG to compare 14-day Instagram Reels engagement across January and February signup cohorts.
MetaCalculate daily net cash movement and running balances for Alpaca brokerage accounts using a CTE, subquery, and window function.
Alpaca
Goldman Sachs Bank
Grail