60

Category Revenue

MediumJOINSUMGROUP BY

Problem Description

Write a SQL query to calculate total revenue by product category.

Expected Columns

category
total_revenue

Example Output

| category | total_revenue | |----------|---------------| | Electronics | 234500 | | Furniture | 42000 | | ... | ... |

Hints

Unlocks after 2 more attempts

Submit your solution to unlock hints

Related Topics

JOINSUMGROUP BYarithmetic

//#60 Category Revenue

Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results