Sales Performance by State & Region

explore
SQL Essentials Skill Path
Sales Performance by State & Region

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