Extract and manipulate relevant data to generate the required report.
Present data in a clear and easy-to-understand tabular format.
Enhance SQL skills with complex queries for data extraction and manipulation.
Overview
GlobalMart aims to design a loyalty program by categorizing customers into Promoters, Potentials, and Detractors based on calculated scores derived from purchase behavior metrics to enhance customer insights and engagement.
Prerequisites
Understanding of basic SQL queries, joins, and aggregate functions.