Search⌘ K
AI Features
Home
Courses
SQL Interview Preparation

Answer: Aggregate Records Using AVG

Explore the use of the SQL AVG function to compute average prices grouped by category. Understand how to apply aggregate functions, set aliases, and use GROUP BY clauses effectively to summarize data. This lesson also discusses alternate solutions like JOINs and highlights common pitfalls when filtering with aggregates.

We'll cover the following...

Solution

The solution is given below:

MySQL
/* The query to find the average price of products for each category */
SELECT   Category, AVG(Price) AS AveragePrice
FROM     Products
GROUP BY Category;

Explanation

The explanation of the solution code is given below:

  • Line 2: The SELECT query selects the Category column and the average price of the Price column by calculating it using the AVG function. We use AS to set an alias for the column.

  • Line 3: The FROM clause specifies the table, Products. ...