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

Write a query to find all customers who made at least one purchase in the last 30 days from the most recent order date. Return customer_id, customer_name, and their last order date.

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