Understanding Grouping and Aggregation in SQL: A Deep Dive into Using `GROUP BY` with Additional Columns