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

Sales Performance by State & Region

5 Inputs
30 Minutes
Advanced
scenario poster
Industry
e-commerce
Skills
data-wrangling
Tools
sql

Learning Objectives

To apply the concepts of windowing
To calculate totals, running totals and contributions

Overview

Apply windowing operations to prepare a report on sales performance of the company by region and state

Prerequisites

  • Ability to perform joins, aggregations, CTEs