The following table lists the most important built-in date functions in MySQL:
FunctionDescription
NOW()Returns the current date and time
CURDATE()Returns...
SQL aggregate functions return a single value, calculated from values in a column.
FunctionDescription
AVG()Returns the average value
COUNT()Returns...