Recent Orders

How can we retrieve orders from the last 30 days dynamically?

Advanced⏱ 3 Minutes⭐ 1430 XP

🤔 THE QUESTION

How can we retrieve orders from the last 30 days dynamically?

💡 WHAT IS IT?

Subtracting INTERVAL '30' DAY from CURRENT_DATE filters for trailing rolling-window periods.

🎯 WHAT IS IT USED FOR?

Last 30 days dashboard widgets, active customer tracking, recent SLA compliance.

💻 EXAMPLE

SELECT *
FROM orders
WHERE order_date >= CURRENT_DATE - INTERVAL '30' DAY;

Practice typing production-grade SQL code for Recent Orders.