CUSTOMER INVOICE PK CUS_CODE INT(5) PK INV_NUMBER INT(5) FK CUs CODE INV DATE CUS LNAME VARCHAR(50) INT(5) CUS FNAME CUS INITIAL CUS AREACODE CUS PHONE CUS BALANCE VARCHAR(50) DATETIME CHAR(1) LINE...

A) Write the SQL code that will create the table structure for table: PRODUCT.
Note:
P_CODE is the Primary Key
V_CODE is the Foreign Key that references the VENDOR table

B) Write the SQL code to enter two rows in the table VENDOR table.

C) Write a SQL to compute and display for each Customer the Total Purchases, Number of Purchases and Average Purchases when the Total Purchases are less than 2000 dollars.

Extracted text: CUSTOMER INVOICE PK CUS_CODE INT(5) PK INV_NUMBER INT(5) FK CUs CODE INV DATE CUS LNAME VARCHAR(50) INT(5) CUS FNAME CUS INITIAL CUS AREACODE CUS PHONE CUS BALANCE VARCHAR(50) DATETIME CHAR(1) LINE CHAR(3) PK. CHAR(8) INV NUMBER INT(5) FK DECIMAL(13,2) PK LINE NUMBER INT(2) FK P CODE INT(5) INT(4) DECIMAL(13,2) LINE_UNITS PRODUCT LINE_PRICE VENDOR PK V_CODE INT(5) PK P_CODE INT(5) V_NAME P_DESCRIPT VARCHAR(50) VARCHAR(50) VARCHAR(50) V_CONTACT P_INDATE DATETIME V_AREACODE VARCHAR(50) P_QOH INT(4) VARCHAR(50) V_PHONE V_STATE V ORDER P_MIN INT(4) VARCHAR(50) P_PRICE DECIMAL(13,2) P DISCOUNT DECIMAL(13,2) INT(5) VARCHAR(50) FK V_CODE