In SQL, use aggregate functions to calculate summary statistics. For instance, employ `COUNT(*)` for total rows, `SUM(column)` for total, `AVG(column)` for average, and `MIN(column), MAX(column ...

One way to calculate a moving average with SQL is to use the AVG function with the OVER clause. The OVER clause allows you to specify a window frame that defines the range of values to be averaged.