I ❤️ being a software engineer
combines columns into a new table
rAllows us to aggregate columns per some category
retrieve information from a table with statements