Sometimes, we are just looking for information about our data. For this, MariaDB has several built-in functions:
AVG function is used for obtaining the average of the data in a column. For example, combined with the
CURDATE functions, we can use the
AVG function to calculate the average age of all of the people in the employees table.
CURDATE function doesn't take any arguments and when called, it simply returns the current date.
TIMESTAMPDIFF function takes three arguments—the unit to count by and two dates, and then outputs the difference between the two. The unit is one of several time units, including