Search⌘ K
AI Features
Home
Courses
SQL Interview Preparation

Answer: The GROUP BY Clause and the SUM Function

Explore how to use the SQL GROUP BY clause to group records and apply the SUM aggregate function to calculate total values per category. Understand the role of SELECT, FROM, aliases, and aggregate functions, and see alternate query methods like subqueries. This lesson prepares you to write efficient grouped queries and solve related interview problems.

We'll cover the following...

Solution

The solution is given below:

MySQL
/* The query to find the total price of products for each category */
SELECT   Category, SUM(Price) AS TotalPrice
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 total price of the Price column by calculating it using the SUM function. We use AS to set an alias for the column.

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