Back to problems

DE / AE Onsite: Data Modeling (Fitness App)

SQL · DoorDash · Hard

Requirements Create a relational schema for a fitness application covering users, workouts, workout sessions, and devices. Define a daily active user as someone who records at least one workout session on a particular calendar day. Write SQL that returns DAU for any supplied start and end dates. Be prepared for one or two SQL extensions selected by the interviewer, such as MAU, weekly retention, or each user's most frequent workout types. Examples Example 1 Input: Use the…

Checking your access…