MySQL

Q.4) (25 points) Use the ap database for this question. Write a query that replicates the result set below matching all data and format aspects, including column headers invoice id account description line item description line item amount 2051.59 2115.81 2184.11 2184.50 2312.20 2318.03 2433.00 2765.36 3689.99 3813.33 4901.26 6940.25 7125.34 10976.06 20551.18 21842.00 23517.58 26881.40 37966.19 103 Freight 63 Freight 51 Freight 79 Direct Mail Advertisin 60 Freight Freight Freight Freight PC card deck Freight Freight 80 Freight 56 Books, Dues, and Subscriptions Card deck 45 Freight 107 Freight Freight Freight Freight Office lease OS Utilities Web site design VSAM book printin CICS book printin Book repro DB2 book printin MVS JCL CICS Desk Reference 1 Freight 21 Outside Services 65 Book Printing Costs 31 Outside Services 112 Book Printing Costs 102 Book Printing Costs 43 Book Printing Costs 106 Book Printing Costs 96 Book Printing Costs 39 Book Printing Costs 19 result rows returned E ap Tables general-edger-accounts Columns account-number account-description ep Indexes PRIMARY account-description Foreign Keys Triggers invoice archive [05] Columns invoice id vendor_id invoice number invoice date invoice total payment_total credit_total credit total terms-id invoice due date payment-date Indexes Foreign Keys Triggers | | invoice line items [05] Columns invoice id invoice-sequence account-number line item amount line_item_description Indexes PRIMARY line items fk acounts VE Foreign Keys line items_fk_invoices line items fk acounts line_items_fk_invoi line_items_fk_invoi ces > Triggers | | invoices VColumns invoice id vendor_id invoice number invoice date invoice total payment_total credit total terms_id invoice due date payment-date ep Indexes PRIMARY invoices-fk-vendors invoices_fk_terms invoices_invoice_date_i Foreign Keys Foreign Keys invoices fk terms invoices_fk_vendons Triggers terms LD] Columns terms-id terms, description terms, due, days ep Indexes PRIMARY Foreign Keys Triggers | | vendor contacts Columns vendorid last_name first_name - ep Indexes PRIMARY Indexes PRIMARY Foreign Keys ] Triggers vendors LD] Columns vendorid - vendor name vendoraddress! vendoraddress2 - - vendor_city vendor state vendor-zip-code vendor_phone vendor contact last name vendor contact first name default-term sid default account number ep Indexes PRIMARY