SQLQuokkaSQLQuokkaA mobile game studio tracks day-one retention. activity has one row per player per day they logged in, and rows are not stored in date order. A player returned on day one when they have a login exactly one calendar day after their first-ever login date. Write an SQL query that returns a single column, day_one_return_rate: the fraction of all players who returned on day one, as a number between 0 and 1 rounded to 2 decimal places.
Loading…
Try solving the question with the schema explorer and hints first. When ready, reveal the verified canonical query and step-by-step logic breakdown.
Ask questions, share alternate queries, and explore solutions
Your recent query executions and answer checks
This will insert the verified MySQL solution into your editor so you can study how each clause transforms the table.