Question library
Questions from real interviews. Drill any of them by voice in a couple of minutes, with an interviewer, a score and feedback.
How would you calculate user retention for a mobile app?JuniorThere's a users table with the columns user_id and signup_date, and an events table with the columns user_id and event_time. Write a SQL query that, for each weekly signup cohort, returns the cohort size and day-7 retention: the share of users who had at least one event exactly seven days after signing up.Mid-level