Monthly Cohort Retention

Quick Overview

This question evaluates practical SQL skills in user retention analysis, specifically the ability to build a monthly cohort retention table from raw activity logs. It tests date truncation, window-based grouping, and aggregation logic commonly required in data science and analytics roles. The question targets applied SQL proficiency and product analytics thinking under real-world schema constraints.

Monthly Cohort Retention

Company: Amazon

Role: Data Scientist

Category: Data Manipulation (SQL/Python)

Difficulty: medium

Interview Round: Technical Screen

Quick Answer: This question evaluates practical SQL skills in user retention analysis, specifically the ability to build a monthly cohort retention table from raw activity logs. It tests date truncation, window-based grouping, and aggregation logic commonly required in data science and analytics roles. The question targets applied SQL proficiency and product analytics thinking under real-world schema constraints.

|Home/Data Manipulation (SQL/Python)/Amazon
Amazon logo
Amazon
Jun 8, 2026, 12:00 AM
mediumData ScientistTechnical ScreenData Manipulation (SQL/Python)
3
0
PracticeRead
Loading...
Loading comments...

Browse More Questions

More Data Manipulation (SQL/Python)•More Amazon•More Data Scientist•Amazon Data Scientist•Amazon Data Manipulation (SQL/Python)•Data Scientist Data Manipulation (SQL/Python)