Very Important crosS Applying yaK Herder
SELECT AVG( price * 1.0 ) * 100
SELECT SUM( price * 1.0 ),COUNT(price)
quote:Originally posted by aboyseThat's good but it only shows the number of rows which is 10... Doesn't give a average of the money for the rooms.
quote:Originally posted by aboyseyes it gave me the sum of 0 and it counted 10 rows of info: not exactly what I want...
SELECT SUM( ABS(price) * 1.0 ),COUNT(price),AVG(ABS(price) * 1.0)