Type in the blank provided the SQL statement that constructs

Type in the blank provided the SQL statement that constructs a new table in the \"SALES\" database that is shown in the image below. type your text here LINE PK INV NUMBER INTEGER LINE NUMBER INTEGER PK P CODE STRING (MAX 4 CHARACTERS) LINE UNITS INTEGER LINE PRICE INTEGER Remember the semicolon at the end of the statement, no spaces after the commas and only one space between commands, and use ALL CAPS! ozols cereage leansie Rearved Maynot be scanned copiedarduplcated, or posted tea publelvacresteir webste in whole part MacBook Air

Solution

create table SALES ( INV_NUMBER integer not null,LINE_NUMBER integer not null,P_CODE varchar(4),LINE_UNITS integer,LINE_PRICE integer,primary key (INV_NUMBER , LINE_NUMBER ));