Answer: Aggregate Records Using AVG
Find a detailed explanation of using the AVG function to aggregate records in a table using SQL query.
Solution
The solution is given below:
Press + to interact
/* The query to find the average price of products for each category */SELECT Category, AVG(Price) AS AveragePriceFROM ProductsGROUP BY Category;
Explanation
The explanation of the solution code is given below:
Line 2: The
SELECT
query selects theCategory
column and the average price of thePrice
column by calculating it using theAVG
function. We useAS
to set an alias for the column.Line 3: The
FROM
clause specifies the table,Products
.Line 4: ...
Level up your interview prep. Join Educative to access 70+ hands-on prep courses.