← SQL & Data Engineering / 16

hardMeta AmazonNetflix

Write SQL for a cohort retention analysis (what % of users return in week N after signup).

The canonical product-analytics SQL question. The signal is grouping users by signup cohort, computing each activity's period offset, and counting distinct returners per offset to build the retention triangle.

Updated Aug 2026 · Grounded in real Applied AI Engineer interview loops and written to a senior-engineer editorial bar.

The canonical product-analytics SQL question. The signal is grouping users by signup cohort, computing each activity's period offset, and counting distinct returners per offset to build the retention triangle.

more free answers with an account · no card

UP NEXT ON YOUR JOURNEY

Next in this trackExplain SQL join types (inner, left/right/full outer, semi, anti, cross) and when to use each.Next in this trackCompute a 7-day moving average and other rolling aggregates with SQL window frames.Next in this trackHow do you compute percentiles, medians, and quantile buckets in SQL?

DISCUSSION · 0

No comments yet — be the first to share your approach.