STATISTICS IN SQL

Note: Can be done in the database, but best done in a spreadsheet or using statistics software!

AVG

Mode

Price frequency

Price mode

Median (concept)

Ranking

Products numbered consecutively

Numbered customers

Running sum

Running Total for Orders

Running Total and Count for Orders