SUMGROUP BY clauseGetting summarizing valuesRunning totalsCorrelated subqueriesGetting summarizing valuesSELECT statement