Coding Exercise: Analyzing Best-Selling Categories

Practice using SQL to analyze tabular data and extract meaningful insights.

Scenerio

Imagine that you are a junior data scientist at a retail company, and you’ve been asked to generate a category-wise revenue report, but only for sales that occurred in May 2024. Your company is launching a new product line, and management wants to focus on categories that generated more than $100 in revenue.

Dataset

Let’s look at the relational tables you will be working on. The first table is the Sales table with the following entries:

Get hands-on with 1400+ tech skills courses.