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 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: ...