Skip to main content
SQL โ€ข LESSON 126

Date Range

How can we filter records within a specific fiscal quarter?

Advancedโฑ 3 Minutesโญ 1390 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