Which of the following statement is NOT correct ?
A. By default, ORDER by clause sorts the result set in decreasing order
B. SUM() function is used to count the total no. of records in a table
C. By default, ORDER BY clause sorts the results set in increasing order
D. AVG() is an aggregrate function
E. The WHERE clause is used to specify filtering conditions for groups
Consider the correct answer from the options given below :