Sales by Category
ASKED IN INTERVIEWe Bay
Problem Statement
eBay marketplace analysts need to report on category performance for the current year (2026).
Write an SQL query to calculate the total sales amount for each product category for all orders placed in 2026.
Rules:
- Only include orders placed between 2026-01-01 and 2026-12-31.
- If a category has no sales in 2026, it does not need to be included in the result.
- Output columns: category_name, total_sales.
- Results must be sorted by total_sales in descending order. If sales are equal, sort by category_name in ascending order.
Tests your understanding of
Joins, Aggregation and Date Filtering
Input Tables
sales
| order_id(INTEGER) | product_id(INTEGER) | order_date(DATE) | price(DECIMAL) |
|---|---|---|---|
| 1 | 101 | 2026-02-01 | 150 |
| 2 | 101 | 2026-02-15 | 150 |
| 3 | 102 | 2026-03-01 | 300 |
| 4 | 103 | 2025-12-31 | 50 |
| 5 | 104 | 2026-01-01 | 100 |
products
| product_id(INTEGER) | product_name(VARCHAR) | category_id(INTEGER) |
|---|---|---|
| 101 | Leather Jacket | 1 |
| 102 | Smartphone | 2 |
| 103 | Toaster | 3 |
| 104 | Jeans | 1 |
categories
| category_id(INTEGER) | category_name(VARCHAR) |
|---|---|
| 1 | Fashion |
| 2 | Electronics |
| 3 | Home Appliances |
Expected Output
| category_name(VARCHAR) | total_sales(DECIMAL) |
|---|---|
| Fashion | 400 |
| Electronics | 300 |
Tags
EasyASKED IN INTERVIEWJoinsAggregationDate Filtering
10-15 min
81%