Check out a free preview of the full SQL Fundamentals course:
The "Aggregate Functions and GROUP BY Exercise" Lesson is part of the full, SQL Fundamentals course featured in this preview video. Here's what you'd learn in this lesson:
In this exercise, students need to get the subtotal of an order’s line items and display it prominently at the bottom of the order page. Then, students count and concatenate aggregate results as we group records on the employee, customer, and product list pages.