For more information:
- To learn more about the DATE_FORMAT built-in function, visit https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-format.
- To learn more about the TIME_FORMAT built-in function, visit https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_time-format.
- To learn more the ADDDATE built-in function INTERVALS, visit https://dev.mysql.com/doc/refman/8.0/en/expressions.html#temporal-intervals.
- To learn more about variance and standard deviation, visit https://www.khanacademy.org/math/probability/data-distributions-a1/summarizing-spread-distributions/v/range-variance-and-standard-deviation-as-measures-of-dispersion.
- To learn more about the Oracle EXTRACT function, visit https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions050.htm.
- To learn more about the PostgreSQL EXTRACT function,...