Strong First Game Sessions

A gaming platform records every completed play session. The analytics team wants to understand how many players made a strong first impression.

Table: player_sessions

+------------+-----------+
| Column Name| Type      |
+------------+-----------+
| session_id | integer   |
| player_id  | integer   |
| score      | integer   |
| started_at | timestamp |
+------------+-----------+
+------------+-----------+
| Column Name| Type      |
+------------+-----------+
| session_id | integer   |
| player_id  | integer   |
| score      | integer   |
| started_at | timestamp |
+------------+-----------+

session_id is the primary key. Each row represents one completed game session by a player.

For each player, identify their first session by the earliest started_at. If a player has multiple sessions at the same earliest timestamp, treat the row with the smaller session_id as the first session.

Calculate the percentage of players whose first-session score was at least 500. Return the percentage on a 0-to-100 scale, rounded to 2 decimal places, in a column named strong_start_pct.

If the table is empty, return 0.

Example

Input:

player_sessions table:
+------------+-----------+-------+---------------------+
| session_id | player_id | score | started_at          |
+------------+-----------+-------+---------------------+
| 1          | 1         | 200   | 2026-01-01 12:00:00 |
| 2          | 1         | 900   | 2026-01-02 12:00:00 |
| 3          | 2         | 600   | 2026-01-05 09:00:00 |
| 4          | 2         | 100   | 2026-01-07 09:00:00 |
| 5          | 3         | 700   | 2026-01-10 15:30:00 |
+------------+-----------+-------+---------------------+
player_sessions table:
+------------+-----------+-------+---------------------+
| session_id | player_id | score | started_at          |
+------------+-----------+-------+---------------------+
| 1          | 1         | 200   | 2026-01-01 12:00:00 |
| 2          | 1         | 900   | 2026-01-02 12:00:00 |
| 3          | 2         | 600   | 2026-01-05 09:00:00 |
| 4          | 2         | 100   | 2026-01-07 09:00:00 |
| 5          | 3         | 700   | 2026-01-10 15:30:00 |
+------------+-----------+-------+---------------------+

Output:

+------------------+
| strong_start_pct |
+------------------+
| 66.67            |
+------------------+
+------------------+
| strong_start_pct |
+------------------+
| 66.67            |
+------------------+

Explanation:

Player 1's first session scored 200, so it does not qualify. Players 2 and 3 scored at least 500 in their first sessions. Two of the three players qualify, so the result is 66.67.