Clinical Trials & Research Analytics Path · Mission 24 of 25Master

Patient retention curve — Kaplan-Meier-style step function

Generated time-points (CROSS JOIN), at-risk denominator, and survival fraction at each time-point. Practice the survival-analysis structure in pure SQL — the same shape powers customer retention curves, equipment failure analysis, and any 'how many of the original cohort are still active at time T' question.

The Brief

You'll practice

Generated time-points CROSS JOINSurvival fractionVisit-log proxy for last seen