Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

18. Retail Expansion Analysis (Medium)
Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Problem Statement

Table: StorePerformance
Each row in this table represents a store, detailing its unique ID, revenue in 2020 and 2021, and its geographical coordinates.

+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| store_id    | int     |
| rev_2020    | float   |
| rev_2021    | float   |
| lat         | float   |
| lon         | float   |
+-------------+---------+
store_id is the primary key for this table.
rev_2020 and rev_2021 represent the store's revenue in 2020 and 2021, respectively.

.....

.....

.....

Like the course? Get enrolled and start learning!

Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible