Skip to content

Instantly share code, notes, and snippets.

@SudhakarReddyPeddinti

SudhakarReddyPeddinti/SQL

Created August 20, 2016 17:19
Show Gist options
  • Save SudhakarReddyPeddinti/b276c62dc7b248798b3e61b8965275ed to your computer and use it in GitHub Desktop.
Save SudhakarReddyPeddinti/b276c62dc7b248798b3e61b8965275ed to your computer and use it in GitHub Desktop.
Download ZIP
STD calculation, Copy average values into other table - MySql
Raw
SQL
// 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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment