Menu
CoddyTech

Dispatch Calendar

Part of the SQL Foundations section of Coddy's PostgreSQL journey. Lesson 10 of 22.

challenge icon

Challenge

Medium

For orders dated before 2025-02-03, return id, order_month and dispatch_date. order_month is the first day of the order month; dispatch_date is three days after the order. Return dates, ordered by id.

The input tables are shown in the test panel. Each run starts from fresh data. Return the named columns in the stated order; do not hard-code the displayed rows.

Try it yourself

-- Write your SQL here.

All lessons in SQL Foundations

Practice on your own: PostgreSQL playground