Orders on Public Holidays

Return the ids of orders placed on a public holiday listed in the Holidays table. Order by id.

Table schema

Orders(id INT PRIMARY KEY, order_date DATE)
Holidays(holiday_date DATE PRIMARY KEY)

Sample data

Orders: (1, 2026-10-02), (2, 2026-10-03), (3, 2026-10-20)
Holidays: 2026-10-02, 2026-10-20