Scenario SQL Question

Find Active Customers in Last 30 Days

Build mastery in Date Operations with this scenario-based SQL challenge and live execution support.

Problem Statement

Identify customers who placed at least one order within 30 days of the most recent order in the dataset. Return customer_id, customer_name, and last_order_date — ordered by last_order_date DESC, customer_id.

Relevant Tables

customersorders

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

Date & Time FunctionsSQL Fundamentals
Range & Interval FilteringAdvanced Filtering
NULL HandlingSQL Fundamentals