The COUNT() function returns the number of rows that matches a specified criterion. MySQL provides us with aggregate functions like COUNT(), SUM() and AVG() for these purposes. COUNT() is used to count the number of rows for a given condition. COUNT() works on numeric as well as non-numeric values. SUM() is used … Continue reading MySQL COUNT(), AVG() and SUM() Functions