SQL Server 2017

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

CREATE TABLE mytable(
   System_Name       VARCHAR(7) NOT NULL 
  ,Most_Recent_Score INTEGER  NOT NULL
  ,Test_Date         DATE  NOT NULL
);
INSERT INTO mytable(System_Name,Most_Recent_Score,Test_Date) VALUES ('system1',84,'2019-06-10');
INSERT INTO mytable(System_Name,Most_Recent_Score,Test_Date) VALUES ('system1',87,'2019-08-24');
INSERT INTO mytable(System_Name,Most_Recent_Score,Test_Date) VALUES ('system1',94,'2019-09-14');
INSERT INTO mytable(System_Name,Most_Recent_Score,Test_Date) VALUES ('system2',78,'2019-07-22');
INSERT INTO mytable(System_Name,Most_Recent_Score,Test_Date) VALUES ('system2',85,'2019-09-12');
INSERT INTO mytable(System_Name,Most_Recent_Score,Test_Date) VALUES ('system3',65,'2019-05-23');
INSERT INTO mytable(System_Name,Most_Recent_Score,Test_Date) VALUES ('system3',74,'2019-07-03');
INSERT INTO mytable(System_Name,Most_Recent_Score,Test_Date) VALUES ('system3',81,'2019-08-09');
INSERT INTO mytable(System_Name,Most_Recent_Score,Test_Date) VALUES ('system3',91,'2019-09-10');

9 rows affected

System_Name	Most_Recent_Score	Test_Date
system1	94	14/09/2019 00:00:00
system2	85	12/09/2019 00:00:00
system3	91	10/09/2019 00:00:00