fbpx

SQL Data Analysis Exercises – Orders Analysis

This SQL exercise is a part of a section dedicated for data analysts , providing data analysis tasks that require both business understanding and technical skills.
 

About this Exercise

FoodCart is a grocery store located in the US. in this exercise you’re to explore its Order Management System, and analyze data related to orders, items, and customers.

  • Orders – lists the current orders
  • Items – contains the different items of every order
  • Customers – lists the customers

 

Diagram



 

To read more

UpScale Analytics is one of the largest platforms in the world for learning SQL by doing, consisting over 300 SQL exercises at different levels (including solutions), by topics, across over 100 different datasets. More…