- To turn row-level data into columnar data
- To filter data based on a condition
- To sort data in ascending or descending order
- To join data from multiple tables