New User 7-Day Return Rate

SQLMediumMid level~15 min

Problem

**[Widely asked in product analytics interviews]**

A key growth metric: of all users who signed up in January 2023, what percentage
came back and visited the app **at least once in the 7 days following their signup**?

Return three columns:
- `total_signups` — users who signed up in Jan 2023
- `returned_in_7d` — how many visited within 7 days of signup
- `return_rate` — percentage, rounded to 1 decimal place

Tables

Example rows — the live problem includes the full dataset.

signups

signup_id	user_id	signup_date

app_visits

visit_id	user_id	visit_date

Expected output

Your answer should return 1 row with the columns total_signups, returned_in_7d, return_rate.

Starter code (SQL)

SELECT *
FROM signups;

Solve this SQL question free

Write SQL and run it instantly in your browser — even on your phone. No signup needed to try.

Solve it now → Create free account

Solution & explanation

Create a free account to unlock the optimal solution, a step-by-step explanation, and the hidden test cases that grade your answer.