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