Question: Aggregate Records Using AVG
Explore how to use the SQL AVG aggregate function to calculate average product prices within each category. This lesson helps you interpret and write queries that analyze pricing trends in a database, enabling data-driven decisions for e-commerce pricing strategies.
We'll cover the following...
We'll cover the following...
Question
Given the following ...
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 |
...