Design a Query to extract all the invoices and their line items, along with the Ship-to information and contact details for each invoice, as well as the product and associated supplier information for each line-item product, for all the invoices that have a shipToState of ‘NSW’. The information extracted should be the same (though not in the same format) as that which was included in the
sample [url removed, login to view] file.
Generate the XML file for the output, by setting the file output options in DB2XML. Make sure the Query to generate the XML output is included as an attribute of the table element of the XML document, as shown in the above listing. Submit the XML file as the solution to this project.