Arriving Wednesday

Problem

The store delivers in three business days: the count starts the day after the order is placed, and neither Saturday nor Sunday counts. Something ordered on a Monday arrives on Thursday; something ordered on a Saturday arrives on Wednesday.

The '%w' format of STRFTIME gives the day of the week as text from '0' to '6', and '0' is Sunday.

Show three columns: each order's number, its date, and the day it gets delivered. The earliest deliveries go on top and, when the day is the same, the lower order number goes first.

Orders dated up to today, January 15, 2026, are included. The one dated the 20th stays out: with a mistyped date, there's no day to promise.

What it has to return

This is what comes out with the data in the practice database this challenge uses. The column names don’t count, so name yours however you like: what counts is how many there are and the order they come in. Besides this one, the challenge has hidden tests with other data that are revealed when you submit your solution.

You start with this

SELECT id, placed,
  DATE(placed, '+3 days') AS arrives
FROM orders
ORDER BY arrives, id;