interviewReal Business Cases 15m est

Customer Retention Analysis

Problem Statement

Analyze customer retention by finding all customers who placed at least one completed order in February 2026, and also placed at least one completed order in March 2026. Retrieve their customer `id` and `name`. Sort by customer `id` ascending.

Skills Evaluated

JOINDate FilterINTERSECTDeduplication
Write your SQL query in the editor on the right and click **Run Query**. The system runs your query and compares the result dataset with the official solution. Results must match row-for-row, column-for-column.

Expected Output Format

Executing expected result set...
SQL Query WorkspaceSQLite v3.45 (WASM Mode)
QUICK INSERT:
1