What is the SQL command that constructs a new table in the S

What is the SQL command that constructs a new table in the \"SALES\" database that is shown in the image below Drag the options to the provided blanks to construct the SQL statement.

Solution

The folllowing SQL Command will create the \"SALES\" table as expected.

CONSTRUCT TABLE SALES-DATABASE.LINE

CREATE TABLE SALES.LINE IF NOT EXISTS

(

INV_NUMBER INT NOT NULL,

LINE_NUMBER INT NOT NULL,

P_CODE VARCHAR(4),

LINE_UNITS INT,

LINE_PRICE INT,

INV_DATE DATE,

PRIMARY KEY(\'INV_NUMBER\',\'LINE_NUMBER\')

);