MySQL

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 2545443 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-06-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 7. Manion Cena AZIACE CEE 1 A NE 2014 NE The result set contains 29 rows. invoice_line_items invoice_id INT invoice_sequence INT account_number INT line_item_amount DECIMAL(9,2) line_item_description VARCHAR(100) Indexes PRIMARY line_items_fk_acounts vendors vendor_id INT vendor_name VARCHAR(50) vendor_address1 VARCHAR(50) vendor_address 2 VARCHAR(50) vendor_city VARCHAR(50) vendor_state CHAR(2) vendor_zip_code VARCHAR(20) vendor_phone VARCHAR(50) vendor_contact_last_name VARCHAR(50) vendor_contact_first_name VARCHAR(50) default_terms_id INT default_account_number INT Indexes I PRIMARY vendor_name vendors_fk_terms vendors_fk_accounts general_ledger_accounts account_number INT account_description VARCHAR(50) Indexes PRIMARY account_description invoice_archive invoice_id INT vendor_id INT invoice_number VARCHAR(50) invoice_date DATE invoice_total DECIMAL(9,2) payment_total DECIMAL (9,2) credit_total DECIMAL (9,2) terms_id INT invoice_due_date DATE payment_date DATE invoices terms invoice_id INT terms_id INT vendor_id INT terms_description VARCHAR(50) invoice_number VARCHAR(50) terms_due_days INT Indexes invoice_date DATE PRIMARY invoice_total DECIMAL(9,2) payment_total DECIMAL(9,2) 1 credit_total DECIMAL (9,2) >+ terms_id INT invoice_due_date DATE paym ent_date DATE Indexes PRIMARY invoices_fk_vendors invoices_fk_terms invoices_invoice_date_ix