Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Orders in a Date Range

Return all orders placed between 2026-02-01 and 2026-03-15 (both inclusive), ordered by order_date ascending.

Table schema

Orders(id INT PRIMARY KEY, customer_id INT, order_date DATE, amount INT)

Sample data

id | customer_id | order_date | amount
1  | 101 | 2026-01-05 | 250
2  | 102 | 2026-02-14 | 400
3  | 101 | 2026-03-01 | 150
4  | 103 | 2026-03-20 | 300

Discussion

No discussions yet.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.