Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
18. Retail Expansion Analysis (Medium)
On this page

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!

On this page