Question: Below is the question, I need help with question 3. This question is done in Microsoft Sql server and I need it in SQL not

Below is the question, I need help with question 3. This question is done in Microsoft Sql server and I need it in SQL not Oracle.

Below is the question, I need help with question 3. This question

FIGURE 10.1 THE CH10 SALECO DATABASE RELATIONAL DIAGRAM LINE INV NUMBER INM. NUMBER LINE NUMBER CUST NUMBER INV DATE PROD CODE LINE UNITS INV SUBTOTAL INV TAX LINE PRICE PRODUCT INV TOTAL LINE AMOUNT PROD CODE CUSTOMER INV PAY TPE PROD DESCRIPT CUST NUMBER INV PAY AMOUNT PROD INDATE CUST LNAME INV BALANCE PROD.QOH CUST FNAME PROD MIN CUST INITIAL PROD PRICE CUST AREACODI PROD DISCOUNT CUST PHONE VENDOR VEND NUMBER v VEND NUMBER L ACCT TRANSACTION CUST BALANCE V ACCT TRANS NUM VEND-NAME ACCT TRANS DATE VEND CONTACT CUST NUMBER VEND AREACODE ACCT TRANS TYPE VEND PHONE ACCT TRANS AMOUNT VEND STATE VEND ORDER 3. Assume customer 1 purchased 2 items from the store and customer 2 purchased 3 items from the store. Please use insert command to generate the output as shown in the attached document. [3+21 CUSTOMER CUST NUMBER CUST LNAME CUST FNAME CUST INITIAL CUST AREACODE CUST PHONE CUST BALANCE Mron 615 10014 Orlando 222-1672 B 713 442-3381 0 O'Brian 10015 ACCT TRANSACTION ACCT TRANS NUM AccT TRANS DATE CUST NUMBER ACCT TRANS TYPE ACCT TRANSAMOUNT 4243213 2016-11-17 00:00:00.000 10014 charge charge 69.99 2016-11-17 00.00.00.000 10014 1200247 charge 39 4243213 2016-01-18 00:00:00.000 10015 69.99 1200247 2016-01-18 00:00:00.000 10015 charge 637032 2016-01-18 00:00:00.000 10015 charge

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!