1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Butoxors [25]
2 years ago
8

Write a SELECT statement that returns an XML document that contains all of the invoices in the Invoices table that have more tha

n one line item. This document should include one element for each of the following columns:InvoiceNumberInvoiceDateInvoiceTotalInvoiceLineItemDescriptionInvoiceLineItemAmountHint: Below is the SQL part of the query that you should use so that all you have to add is the XML partSELECT InvoiceNumber, InvoiceDate, InvoiceTotal, InvoiceLineItemDescription AS ItemDescription, InvoiceLineItemAmount AS ItemAmountFROM Invoices AS Invoice JOIN InvoiceLineItems AS LineItemON Invoice.InvoiceID = LineItem.InvoiceIDWHERE Invoice.InvoiceID IN (SELECT InvoiceIDFROM InvoiceLineItemsGROUP BY InvoiceID HAVING COUNT(*) > 1)ORDER BY InvoiceDateSave the XML document that is returned in a file named MultipleLineItems.xmlGenerate an XML schema for the file and save it in a file named MultipleLineItems.xsd
Computers and Technology
1 answer:
Alina [70]2 years ago
7 0

Answer:

The code is given, paying attention to every column details

Explanation:

columns:

InvoiceNumber

InvoiceDate

InvoiceTotal

InvoiceLineItemDescription

InvoiceLineItemAmount

SELECT InvoiceNumber, InvoiceDate, InvoiceTotal, InvoiceLineItemDescription AS ItemDescription, InvoiceLineItemAmount AS ItemAmount

FROM Invoices AS Invoice JOIN InvoiceLineItems AS LineItem

ON Invoice.InvoiceID = LineItem.InvoiceID

WHERE Invoice.InvoiceID IN (

SELECT InvoiceID

FROM InvoiceLineItems

GROUP BY InvoiceID

HAVING COUNT(*) > 1)

ORDER BY InvoiceDate

FOR XML RAW, ELEMENTS;

You might be interested in
Which type of loop is best if you do not know how many times you need the loop to run?
Alex
While: <span> the loop must repeat until a certain "condition" is met.  If the "condition" is FALSE at the beginning of the loop, the loop is never executed.  The "condition" may be determined by the user at the keyboard.  The "condition" may be a numeric or an alphanumeric entry.  <span>This is a good, solid looping process with applications to numerous situations. 
</span></span><span>while:<span>int ctr = 1;
while (ctr < = 20)
{
     cout<< ctr++ <<"\n";
}

</span><span>
</span><span>
</span><span>HOPE i HELPED! brainliest? :D </span></span>
5 0
3 years ago
Which spreadsheet feature could the scholarship committee use to locate applicants who meet the criteria?
Radda [10]

Answer:

H8

Explanation:

4 0
2 years ago
Which of the following is not a shared characteristic of new media.
tensa zangetsu [6.8K]
The last one , info is not sparse or little , we have plenty of it
6 0
3 years ago
Blind spots are those areas not reflected in your:
bulgar [2K]
The answer is C because your sideview and rearview mirrors are there specifically to check behind you, while the vanity mirror is not supposed to be used for the same purpose.
8 0
3 years ago
Read 2 more answers
________ is used to install and update software, backup, and restore mobile devices, wipe employer software and data from device
erastovalidia [21]

Answer: MDM softwares

Explanation:

Here MDM refers to mobile device management software which provides people with the facilities of updating, installing creating backup of various mobile devices within an organisation. Moreover these software's provides tools for proper monitoring and to report their usage across various independent mobile device users. MDM is often used or interconnected with the term BYOD(Bring your own device), whereby employees of an organisation bring their own mobile devices and they are being managed by a MDM software centrally.

8 0
3 years ago
Other questions:
  • "where is a cookie that is created during a web site visit​ stored?"
    9·1 answer
  • Which one of these variables has an illegal name?
    11·1 answer
  • Which ergonomic principle helps to maintain good posture?
    7·2 answers
  • The part of the computer that contains the brain or the Central Park nursing unit is also known as
    10·1 answer
  • Which of the following is true about scalability?
    9·1 answer
  • What is the computer that is similar to a destop but smaller in size
    8·1 answer
  • A form letter can be customized by using different fields in a __________.
    15·2 answers
  • Self-confidence, blank, and communication are key factors to building positive relationships. Fill in the blank with a 13 letter
    5·1 answer
  • What icons in the toolbar change the look of the presentation text? It’s either Drawing, Formatting,Presentation, or Standard
    9·2 answers
  • You have been supporting CSM Tech Publishing's Windows Server 2016 server network for over a year. The office has two Windows Se
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!