[SQL] Averaging HH:MM:SS.MM

Hi, I am working on a project that has all my Rubik’s cube solve times in it. There are two tables: “Players” and “Solves”. “Solves” contains the ID # of the person that solved it, the time it took to solve(In a HH:MM:SS.MM format), and the date it was solved. The “Players” table has the names, ID Numbers, and Avg. Solve times of all the solvers. My problem is that I want to find the average solve time based on that person’s solves and put that data as the average solve time in the “Players” table.

My Code:

CREATE TABLE "Solves" (
	"PlayerID"	INTEGER NOT NULL,
	"SolveTime"	varchar(11) NOT NULL,
	"DateSolved"	DATE NOT NULL
);

CREATE TABLE "Players" (
	"ID"	INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
	"Name"	TEXT NOT NULL,
	"AvgSolveTime"	TIME #This is what needs to be updated
);

INSERT INTO Players (Name) 
VALUES ("ProStar");

INSERT INTO Solves (PlayerID, SolveTime, DateSolved) 
VALUES (1, "00:04:29.96", 8/29/19); 

INSERT INTO Solves (PlayerID, SolveTime, DateSolved) 
VALUES (1, "00:06:08.00", 8/29/19);

I have attempted to run a lot of code to get the Average solve time based on what I’ve found on the internet, but I cannot get it to work.

Thanks,
ProStar