Skip to main content
SQL • LESSON 126

Date Range

How can we filter records within a specific fiscal quarter?

Advanced3 Minutes1390 XP
🤔 THE QUESTION

How can we filter records within a specific fiscal quarter?

💡 WHAT IS IT?

BETWEEN on date columns retrieves all events that occurred between start and end dates inclusively.

🎯 WHAT IS IT USED FOR?

Q1 quarterly reporting, monthly audit lookups, seasonal campaign analytics.

💻 EXAMPLE
SELECT *
FROM orders
WHERE order_date BETWEEN '2025-01-01' AND '2025-03-31';

🎯 Mission Objectives

Practice typing production-grade SQL code for Date Range.

  • Date BETWEEN
  • Quarterly range
  • Temporal boundaries
  • Financial auditing