write it by the keyboard

CREATE TABLE sales year SMALLINT NOT NULL, quarter' TINYINT NOT NULL, region VARCHAR(50) NOT NULL, vehicle VARCHAR (50) NOT NULL, quantity SMALLINT NULL, CONSTRAINT pri sales PRIMARY KEY (year', 'quarter, region, vehicle)); [3] 3] e) Continuing with the preceding scenario, suggest a new non-clustered index to stop the query optimizers having to resort to a table scan [3]