Find all orders placed in 2024.

Problem Statement

<p>Find all <code>orders</code> placed in 2024.</p>

Examples

Input: orders table: +----+------------+-------+ | id | order_date | total | +----+------------+-------+ | 1 | 2024-03-15 | 100 | | 2 | 2024-07-22 | 200 | | 3 | 2023-12-01 | 150 | +----+------------+-------+

Output: +----+--------------------------+-------+ | id | order_date | total | +----+--------------------------+-------+ | 1 | 2024-03-15T00:00:00.000Z | 100 | | 2 | 2024-07-22T00:00:00.000Z | 200 | +----+--------------------------+-------+

Explanation: Only records matching the specified criteria are returned in the final result.

Complexity

Time Complexity: -

Space Complexity: -

Hints

💡 Hint 1: Identify the filtering conditions needed to isolate the target rows from the table. 💡 Hint 2: Use appropriate operators: = for exact matches, LIKE for wildcard patterns, IN for sets, or BETWEEN for numeric/date ranges. 💡 Hint 3: Combine filters with AND/OR if multiple conditions exist: SELECT <cols> FROM <table> WHERE <condition>;

Editorial & Approach

Problem Overview & Intuition

To solve "Date Filtering (Current Date)", we query the relational database engine using declarative SQL. The goal is to find all orders placed in 2024. By formulating an optimal execution plan with appropriate projection and filtering, the database engine executes the query with minimal overhead.

Step-by-Step Approach

Analyze Schema: Identify the target tables, necessary foreign keys, and expected output columns.
Construct Filtering & Logic: Apply WHERE filtering to isolate the requested data.
Format & Order: Ensure columns match the expected project schema in order.

Optimal Implementation (SQL)

SELECT * FROM orders WHERE EXTRACT(YEAR FROM order_date) = 2024;

Complexity Analysis

Time Complexity O(N) full table scan or O(log N) if filtered column is indexed.

Space Complexity O(K) where K is the number of filtered rows returned.

Key Considerations & Edge Cases

Empty Tables: The query executes safely returning zero rows without syntax error.
NULL Values: Columns containing NULL values are properly handled by standard ANSI SQL semantics.
Case Sensitivity: String comparisons and keywords adhere to PostgreSQL/standard SQL rules.

Date Filtering (Current Date)

Medium

Find all orders placed in 2024.

Example Scenarios

1Example 1

Input:

orders table

id	order_date	total
1	2024-03-15	100
2	2024-07-22	200
3	2023-12-01	150

Output:

id	order_date	total
1	2024-03-15T00:00:00.000Z	100
2	2024-07-22T00:00:00.000Z	200

Explanation:

Only records matching the specified criteria are returned in the final result.

SQL Editor

Loading Editor...

Query Results

Run a query to see results here.