Would anyone know how to code this in SQL? I can't quite figure
it out.
The following drop command is inserted for convenience so that
if you need to recompile your code, it will drop the table
DROP TABLE Orders Cascade constraints
DROP TABLE OrderLine CASCADE CONSTRAINTS;
-- CREATE TABLE Orders
(
ordernum INTEGER PRIMARY KEY,
priority CHAR(10) NOT NULL,
cost INTEGER NOT NULL, /*
IC1: The priority is one of: high, medium, or low */
>>
/* IC2: The...