Coding Exercise: Analyzing Best-Selling Categories
Explore how to write SQL queries that filter and aggregate sales data to find categories generating over $100 in revenue in May 2024. Learn to join tables and use GROUP BY and SUM for data analysis.
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’ ...