Question

Which of the following is not an aggregate function in MYSQL? 

Options

• AVG()

• MAX()

• LCASE()

• MIN()

Answer 1

LCASE()

Explanation:

Combining aggregate functions with WHERE, GROUP BY, HAVING, and ORDER BY clauses in MySQL databases allows for more complex calculations and analysis. Some of the aggregate functions are COUNT(), SUM(), AVG(), MIN(), MAX(), GROUP(), and CONCAT().