Next-Day Return Rate
Hard
Advanced Queries
Find the percentage of users who logged in again on the day immediately after their first login day, rounded to two decimals. Return it as next_day_return_rate.
Table schema
Logins(user_id INT, login_date DATE)Sample data
user_id | login_date
1 | 2026-03-01
1 | 2026-03-02
2 | 2026-03-01
3 | 2026-03-01
3 | 2026-03-05
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.