Question: The GROUP BY Clause and the SUM Function
Learn how to use the GROUP BY clause to group records using an SQL query.
We'll cover the following...
We'll cover the following...
Question
Given the following Products table structure:
Products
ProductID | ProductName | Category | Price | UnitsSold |
1 | Smartphone | Electronics | 599.99 | 100 |
2 | Laptop | Electronics | 999.99 | 50 |
3 | Headphones | Electronics | 149.99 | 75 |
4 | T-shirt | Apparel | 19.99 | 200 |
5 | Jeans | Apparel | 39.99 | 150 |
6 | Running shoes | Footwear | 79.99 | 100 |
7 | Bagpack | Accessories | 49.99 | 80 |
Additional information
You are provided with a table named Products that contains the following columns: ...