Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Average Score of Returning Players

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.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.