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 ine_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 Advertising 60 Freight 80 Freight 56 Books, Dues, and Subscriptions Card deck 45 Freight 107 Freight Freight Freight Freight PC card deck Freight Freight 1Freight 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 96Book Printing Costs 39 Book Printing Costs Freight Freight Freight Office lease OS Utilities Web site design VSAM book printing CICS book printing Book repro DB2 book printing MVS JCL CICS Desk Reference 19 result rows returned