Question

1 Approved Answer

Posted on Oct 07, 2024

Q4.) (25 points) Use the ap database for this question. Select all invoices due in the month of June and replicate the result set below,

image text in transcribed

Q4.) (25 points) Use the ap database for this question. Select all invoices due in the month of June and replicate the result set below, matching all data and format aspects, including column headers. vendor_name vendor_city/state invoice_number payment_total invoice_date invoice_due_date Compuserve Columbus, OH 21-4923721 9.95 2014-05-13 2014-06-02 Fresno County Tax Collector Fresno, CA PO2-88D7757 856.92 2014-05-03 2014-06-02 Federal Express Corporation Memphis, TN 4-321-2596 10.00 2014-05-05 2014-06-04 Federal Express Corporation Memphis, TN 963253242 104.00 2014-05-06 2014-06-05 Federal Express Corporation Memphis, TN 963253235 108.25 2014-05-11 2014-06-10 Roadway Package System, Inc Pasadena, CA 25022117 6.00 2014-05-01 2014-06-10 Federal Express Corporation Memphis, TN 963253246 129.00 2014-05-13 2014-06-12 Federal Express Corporation Memphis, TN 4-342-8069 10.00 2014-05-14 2014-06-13 Federal Express Corporation Memphis, TN 963253263 109.50 2014-05-16 2014-06-15 Federal Express Corporation Memphis, TN 1-200-5164 63.40 2014-05-20 2014-06-19 IBM San Francisco, CA 9545443 1083.58 2014-06-09 2014-06-19 Roadway Package System, Inc Pasadena, CA 24863706 6.00 2014-05-10 2014-06-19 Digital Dreamworks Fresno, CA PO2-3772 7125.34 2014-05-21 2014-06-20 Zylka Design Fresno, CA 97/486 953. 10 2014-05-21 2014-06-20 Computerworld San Francisco, CA 367447 2433.00 2014-06-11 2014-06-21 Pacific Bell Sacramento, CA 111-92R-10094 19.67 2014-06-01 2014-06-21 Dristas Groom & McCormick Fresno, CA 94007005 220.00 2014-05-23 2014-06-22 Federal Express Corporation Memphis, TN 963253232 127.75 2014-05-23 2014-05-22 Ingram Dallas, TX 31359783 1575.00 2014-06-03 2014-06-23 Federal Express Corporation Memphis, TN 963253260 36.00 2014-05-25 2014-06-24 Pacific Bell Sacramento, CA 111-92R-10097 16.33 2014-06-04 2014-06-24 ASIACE CCC SANCE 1A NC 1 The result set contains 29 rows. Q4.) (25 points) Use the ap database for this question. Select all invoices due in the month of June and replicate the result set below, matching all data and format aspects, including column headers. vendor_name vendor_city/state invoice_number payment_total invoice_date invoice_due_date Compuserve Columbus, OH 21-4923721 9.95 2014-05-13 2014-06-02 Fresno County Tax Collector Fresno, CA PO2-88D7757 856.92 2014-05-03 2014-06-02 Federal Express Corporation Memphis, TN 4-321-2596 10.00 2014-05-05 2014-06-04 Federal Express Corporation Memphis, TN 963253242 104.00 2014-05-06 2014-06-05 Federal Express Corporation Memphis, TN 963253235 108.25 2014-05-11 2014-06-10 Roadway Package System, Inc Pasadena, CA 25022117 6.00 2014-05-01 2014-06-10 Federal Express Corporation Memphis, TN 963253246 129.00 2014-05-13 2014-06-12 Federal Express Corporation Memphis, TN 4-342-8069 10.00 2014-05-14 2014-06-13 Federal Express Corporation Memphis, TN 963253263 109.50 2014-05-16 2014-06-15 Federal Express Corporation Memphis, TN 1-200-5164 63.40 2014-05-20 2014-06-19 IBM San Francisco, CA 9545443 1083.58 2014-06-09 2014-06-19 Roadway Package System, Inc Pasadena, CA 24863706 6.00 2014-05-10 2014-06-19 Digital Dreamworks Fresno, CA PO2-3772 7125.34 2014-05-21 2014-06-20 Zylka Design Fresno, CA 97/486 953. 10 2014-05-21 2014-06-20 Computerworld San Francisco, CA 367447 2433.00 2014-06-11 2014-06-21 Pacific Bell Sacramento, CA 111-92R-10094 19.67 2014-06-01 2014-06-21 Dristas Groom & McCormick Fresno, CA 94007005 220.00 2014-05-23 2014-06-22 Federal Express Corporation Memphis, TN 963253232 127.75 2014-05-23 2014-05-22 Ingram Dallas, TX 31359783 1575.00 2014-06-03 2014-06-23 Federal Express Corporation Memphis, TN 963253260 36.00 2014-05-25 2014-06-24 Pacific Bell Sacramento, CA 111-92R-10097 16.33 2014-06-04 2014-06-24 ASIACE CCC SANCE 1A NC 1 The result set contains 29 rows