31 Mar
Problems with MAX() and MIN() with MySQL
I have been playing around with some data manipulation and performing some basic stats on the data. I used this SELECT statement as a starting point: SELECT Round(STDDEV(Result),2), Round(AVG(Result),2), COUNT(Result), Round(MIN(Result),1), Round(MAX(Result),1) This allowed me get the standard deviation, mean and number of results. The Round refers to rounding the result and the number is [...]