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 INVOICE PK INV MBE INTEGER CUS CODE STRING (MAX 10 CHARACTERS) INV DATE DATE Remember the semicolon at the end of the statement, no spaces after the commas, and use ALL CAPS! C2015 cencage learning AM Rights Reserved May not be scanned. copied or duplicated or posted to a publicly access ble website, n wnoleoninpart MacBook Air delete

Solution

Solution:

CREATE TABLE INVOICE (

INV_NUMBER INTEGER PRIMARY KEY,

CUST_CODE VARCHAR(10),

INV_DATE DATETIME );

Explanation:

Table can be created using create table statement in the below format:

CREATE TABLE Table_NAME

{

COLUMN_NAME Type,

.....

};