task Constraints · hard

Enforce delivery-slot rules

Create delivery_slots with slot_id INTEGER PRIMARY KEY, warehouse_id INTEGER NOT NULL referencing warehouses(warehouse_id), slot_date TEXT NOT NULL that must be a valid YYYY-MM-DD date, capacity INTEGER NOT NULL between 1 and 500, and at most one slot per warehouse and date. Insert (1, 1, '2025-05-01', 120) and (2, 1, '2025-05-02', 80). Return slot_id, warehouse_id, slot_date and capacity.

what to return

Columns

slot_idwarehouse_idslot_datecapacity in this order

Rows

2 rows · any order

Skill

Encode business rules as constraints. Refresher: Constraints protect the data contract →

expected result

Your query should return exactly these columns and values. Run it and compare.

data you can query

Logistics dataset: the first 6 rows of each table. Under each column name: the kind of value it holds, and which table it links to. Your queries run on all rows.