Enqurious LogoTM

Use coupon code 'ENQSPARKS25' to get 100 credits for FREE

0
0
Days
0
0
Hours
0
0
Minutes
0
0
Seconds
Go back

Ranking Top Cities by Sales in Each State for GlobalMart using SQL

7 Inputs
30 Minutes
Intermediate
scenario poster
Industry
e-commerce
Skills
data-wrangling
Tools
sql

Learning Objectives

Extract and manipulate relevant data to generate reports
Ability to use Joins and Aggregation functions to calculate metrics
Practice advanced SQL concepts like CTEs and Window functions for problem solving
Enhance report generation using pivoting operation in SQL
Present data in a clear and easy-to-understand tabular format

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

  • Understanding of basic SQL queries, joins, and aggregate functions.
  • Ability to perform CTEs and Window operations
  • Familiarity with pivoting operation in SQL