Learning objective
- To be able to join tables to bring together columns
- To be able to use popular date functions for data processing
- To be able to perform grouping and aggregations on data
- To be able to implement sub-querying and/or common table expressions
Overview
This practice set provides you an opportunity to demonstrate proficiency in SQL skills like joining, common table expressions, conditional statements, grouping, aggregating
Story
GlobalMart's e-commerce business is booming. Although, this is a great news for the management, The Delivery Ops team has come under huge pressure to ensure deliveries happen in time and with the desired quality.
To ensure close tracking of orders placed, delivered etc. the Head of Delivery Ops has requested the Data Intelligence Team to help them with a Weekly report (to be delivered in the below shown format) :
You as a Data Analyst working with GlobalMart are expected to work on this scenario and offer a solution.
Check out below how will the learning experience in this scenario may look like :