Scenario SQL Question

Shipping SLA Breach (Slower Than 3 Days)

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

Problem Statement

Find orders that took more than 3 days to ship (an SLA breach). Return order_id, customer_id, order_date, ship_date, ship_days, sla_status — for breaches only, ordered by ship_days DESC, order_id.

Relevant Tables

orders

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