Industry
e-commerce
Skills
data-wrangling
Tools
sql
Learning Objectives
Extract and manipulate relevant data to generate the sales report.
Present data in a clear and easy-to-understand tabular format.
Enhance SQL skills with complex queries including window functions
Overview
GlobalMart, a leading e-commerce company, seeks to understand its sales performance across various cities within each state. To achieve this, the management has tasked you with preparing a report that ranks the top three cities by sales for each state. This report will help the company identify high-performing regions, optimize marketing strategies, and allocate resources more effectively.
Prerequisites
- Familiarity with aggregate functions and window functions in SQL.
- Understanding of basic SQL queries, joins, and aggregate functions.