How would you answer an interview scenario involving GroupBy and aggregation in LINQ?

Create a monthly order-total report and explain how to ensure grouping happens in SQL.