What SQL functions would you use to aggregate data and identify patterns in a large dataset, and why?

Technical