// Calculate Average time of Dealers
SELECT DealerID, AVG(ResponseTime) Average FROM DealerUserResponseTime GROUP BY DealerID;


// Insert Average values into other table
INSERT INTO AverageDealerResponseTime SELECT DealerID,AVG(ResponseTime) Average FROM DealerUserResponseTime GROUP BY DealerID;


// Calculate STD of Dealer Response time
SELECT FORMAT(STD(Average),2) FROM AverageDealerResponseTime;