Learning objective
- Be able to join tables to bring together columns
- Be able to use popular date functions for data processing
- Be able to perform grouping and aggregations on data
- 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 is a fast growing E-commerce company which offers highly flexible payment options to its customers like credit card, vouchers etc. The company also offers EMI as an option for the customer to be able to purchase expensive items and pay in several installments.
However, for GlobalMart, one shot payments is also not great because then the customer won't avail EMI option. On the other hand, too long EMI schedules like 12+ months is also not feasible as it prolongs receivables for the company.
The payments team has placed a request with the Data Intelligence Team to help them with some initial insights into the volume of transactions which are short term vs mid term vs long term in terms of EMI payments.
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 :