SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE team_history (ID integer PRIMARY KEY, changed_at TEXT, team TEXT);
INSERT INTO team_history VALUES
 (1,'2021-03-02 10:00:00','B'),
 (2,'2021-03-02 10:00:00','A'),
 (3,'2021-03-02 10:30:00','B'),
 (4,'2021-03-02 10:00:00','A'),
 (5,'2021-03-02 11:30:00','B'),
 (6,'2021-03-02 10:00:00','A'),
 (7,'2021-03-02 11:00:00','B'),
 (8,'2021-03-02 10:00:00','A'),
 (9,'2021-03-02 10:00:00','B'),
 (10,'2021-03-02 10:00:00','A'),
 (11,'2021-03-02 10:00:00','B'),
 (12,'2021-03-02 10:00:00','A'),
 (13,'2021-03-02 10:00:00','B'),
 (14,'2021-03-02 12:30:00','A'),
 (15,'2021-03-02 10:00:00','B'),
 (16,'2021-03-02 12:00:00','A'),
 (17,'2021-03-02 10:00:00','B'),
 (18,'2021-03-02 13:30:00','A'),
 (19,'2021-03-02 10:00:00','B'),
 (20,'2021-03-02 10:00:00','A')
SELECT * FROM team_history GROUP BY team HAVING MAX(changed_at)


ID
changed_at
team


18
2021-03-02 13:30:00
A

5
2021-03-02 11:30:00
B