Tracking Retained Orders at GlobalMart

Learning Objectives

Demonstrate use of JOIN, GROUP BY, and WHERE clause to ensure accurate filtering and calculations.

Demonstrate knowledge of common table expressions (CTEs) to structure and simplify complex queries.

Implement window functions to calculate cumulative totals, percentages, and rankings.

Demonstrate the ability to query data using correlated sub queries

Overview

GlobalMart's management has a million-dollar question: What makes certain orders so perfect that customers never return them? As their analytics expert, you're about to uncover the hidden patterns behind exceptional customer satisfaction.

This isn't ordinary e-commerce analysis—you're investigating the DNA of operational excellence. Your mission: identify every successfully delivered order that customers kept, revealing the secret formula that drives both customer loyalty and profitability across North America and Europe.

The stakes are high. These insights will reshape how GlobalMart approaches product delivery, customer service, and operational strategy. You'll use advanced SQL techniques to dissect millions of transactions, uncovering correlations that could revolutionize their business model.

Ready to decode the science of customer satisfaction?

Prerequisites

Knowledge of basic SQL concepts like SELECT, WHERE, GROUP BY, HAVING, ORDER BY, and JOIN.
Understand common SQL functions like `COUNT`, `SUM`, and `DATEDIFF`.
Know the purpose and use of joins (e.g., INNER JOIN, LEFT JOIN).
Knowledge of window functions like RANK(), DENSE_RANK(), ROW_NUMBER(), and SUM() OVER().
Knowledge of correlated sub queries in SQL.