SQLAdvanced

Orders with line items

PreviousProblem 36 of 40Next

Create:

orders — order_id INTEGER PRIMARY KEY, order_date DATE NOT NULL
order_lines — order_id INTEGER referencing orders, line_no INTEGER, qty INTEGER NOT NULL (must be positive), with (order_id, line_no) as the primary key

This question starts with an empty database.

Hints(0/2)

Each hint gives a little more help. Try on your own first.

Unlocks after you solve it or after 3 submissions

SQLCtrl + Enter to run

Run your code to see the output here.