Question: This must be written in simple SQL. Write a SELECT statement that returns an XML document that contains all of the invoices from the Invoices

This must be written in simple SQL.

Write a SELECT statement that returns an XML document that contains all of the invoices from the Invoices table that have more than one line item. This document should include one element for each of these columns: InvoiceNumber, InvoiceDate, InvoiceTotal, InvoiceLineItemDescription, and InvoiceLineItemAmount. Then, save the XML document thats returned in a filed named MultipleLineItems.xml. Finally, generate an XML schema for the file and save it in a file named MultipleLineItems.xsd.

The data needs to come from two tables: InvoiceLineItems and Invoices. Below are the tables. I can't figure out how to make it pull the invoices that have more than one line item.

This must be written in simple SQL. Write a SELECT statement that

1 USE AP 3 SELECT FROM Invoice tems 5 SELECT FROM Invoices 100% Results Messages InvoiceID invoicesequence AccountNo invoiceLineltemAmount InvoiceLineltemDescription 400 85.31 Book copy 52.25 Freight 572 579.42 Catalog ad 59.97 Freight 101 30.75 Freight 102 20551.18 CICS book printing 105 503.20 Bronco lease 110 90.36 Card deck advertising 10976.06 11 VSAM book printing 10 113 510 224.00 Health Insurance InvoicelD vendor D InvoiceNumber InvoiceDate Invoice Total Payment Total Credit Total TemslD lnvoiceDueDate Payment Date 000 2012-03-10 00:00:00 85.31 2012-04-09 00:00:00 NULL 2012-04-17 00:00:00 NULL 963253264 2012-03-18 00:00:00 52.25 0.00 0.00 31361833 2012-03-21 00:00:00 579.42 2012-04-10 00:00:00 NULL 123 263253268 2012-03-21 00:00:00 59.97 0.00 0.00 101 263253273 2012-03-22 00:00:00 30.75 0.00 0.00 2012-04-20 00:00:00 NULL 2012-04-21 00:00:00 NULL 110 Po608 2012-03-23 00:00:00 20551.18 000 1200.00 3 2012-04-22 00:00:00 NULL 105 106 9982771 2012-03-24 00:00:00 503.20 2012-04-23 00:00:00 NULL 110 134116 2012-04-17 00:00:00 NULL 2012-03-28 00:00:00 90.36 110 02436 2012-03-31 00:00:00 10976.06 0.00 000 11 2012-04-30 00:00:00 NULL 10 113 547480102 2012-0401 00:00:00 224.00 0.00 0.00 37 2012-04-30 00:00:00 NULL

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!

1. Write a SELECT statement that returns an XML document that contains all of the current shipping addresses for the customers in the database. This document should include one element for each of...

1. Write a SELECT statement that returns an XML document that contains all of the invoices in the Invoices table that have more than one line item. This document should include one element for each...

Write a SELECT statement that returns an XML document that contains all of the invoices in the Invoices table that have more than one line item. This document should include one element for each of...

1. Write a SELECT statement that returns an XML document that contains all of the current shipping addresses for the customers in the database. This document should include one element for each of...

I need help with this question ... a. In My SQL write a SELECT statement that returns these columns from the Invoices table: - invoice_number (the invoice_number column) - invoice_total (the...

a. In My SQL write a SELECT statement that returns these columns from the Invoices table: - invoice_number (the invoice_number column) - invoice_total (the invoice_total column) -...

1) Write a SELECT statement that returns two columns from the invoices table: vendorID and paymentSum where paymentSum is the SUM () of the paymentTotal column. (Since we have vendorID in the SELECT...

Oracle SQL Homework: 4. Write a SELECT statement that returns these columns from the Invoices table: The invoice_number column The invoice_date column The invoice_date column plus 30 days The...

.*. TIA .*. SQL 1. Write a SELECT statement that returns two columns based on the EMPLOYEES table. Contact, is the employee lastname and the first initial of the first name. The second column, Phone,...

In SQL, 1. Write a SELECT statement that returns these columns from the Invoices table: - The invoice_total column - A column that uses the FORMAT function to return the invoice_total column with 1...

Roy decides to buy a personal residence, and he goes to the bank for a $150,000 loan. The bank tells Roy that he can borrow the funds at 4% if his father will guarantee the debt. Roy's father, Hal,...

A company makes manufactures shoes. It produces 1 000 pairs of shoes per month. It buys the leather and components from a supplier at a cost of R20 per component kit. The company's inventory carrying...

Annual Costs of Renting. Assume that you rent your apartment for $ 8 9 0 per month, utilities not included. When you moved in , you paid a $ 8 0 0 security deposit using money from your savings...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

LAST WORD What do economists mean when they refer to Social Security as a pay-as-you-go plan? What is the Social Security trust fund? What is the nature of the long-run fiscal imbalance in the Social...

True or False? An increase in the American dollar price of the South Korean won implies that the South Korean won has depreciated in value. Explain.

KEY QUESTION Suppose in Fiscalville there is no tax on the first $10,000 of income, but a 20 percent tax on earnings between $10,000 and $20,000 and a 30 percent tax on income between $20,000 and...