Which aggregate function should you use to find the total revenue per product category?

Question

SQL Fundamentals — Medium

Which aggregate function should you use to find the total revenue per product category?

Accepted Answer

To find the total revenue per product category, you should use the SUM(revenue) function with GROUP BY category. This will calculate the sum of revenue for each unique category. COUNT(revenue) would give the number of revenue entries, AVG(revenue) would give the average revenue, and MAX(revenue) would give the highest revenue value for each category.