Coding Exercise: Analyzing Best-Selling Categories
Explore how to write and run SQL queries that analyze sales data to identify product categories with revenues exceeding $100 in May 2024. Learn to use filtering, aggregation, and table joins to extract clear insights from raw retail datasets.
We'll cover the following...
We'll cover the following...
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’ ...