Average Score of Returning Players
Medium
Gaming Analytics
A returning player has logins on at least two different dates. Return the average score of returning players, rounded to 2 decimals.
Table schema
Logins(player VARCHAR(10), login_date DATE)
Scores(player VARCHAR(10), score INT)Sample data
Logins
player | login_date
P1 | 2026-03-01
P1 | 2026-03-02
P2 | 2026-03-01
P3 | 2026-03-02
P3 | 2026-03-03
P2 | 2026-03-05
P4 | 2026-03-01
P4 | 2026-03-02
Scores
player | score
P1 | 500
P2 | 700
P3 | 700
P4 | 300
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.