MariaDB 10.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table gamestats_players (
  gameID	int,
  playerID	int,
  Team	varchar(20),
  season	int,
  Date	date,
  Points int
);

insert into gamestats_players values
(1,	1,	'Team A',	36,	'2023-04-01',	10),
(2,	1,	'Team A',	36,	'2023-04-02',	10),
(3,	1,	'Team B',	36,	'2023-04-03',	10);

Records: 3  Duplicates: 0  Warnings: 0


SELECT playerID, season, MAX(Date) as latestDate, sum(Points) as total_points
FROM gamestats_players
GROUP BY playerID, season


playerID
season
latestDate
total_points


1
36
2023-04-03
30


select t.playerID, t.Team, t.season, s.total_points
from gamestats_players t
inner join (
  SELECT playerID, season, MAX(Date) as latestDate, sum(Points) as total_points
  FROM gamestats_players
  GROUP BY playerID, season
) as s on s.playerID = t.playerID and s.season = t.season and s.latestDate = t.Date


playerID
Team
season
total_points


1
Team B
36
30