%%%%%%MYSQL%%%%%%%%

Q.3) (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 Contact Full Name Vendor Name Reynaldo Suscipe Abbey Office Furnishings Bruce Onandonga Blanchard & Johnson Associates Geraldine O'Sullivan California Business Machines ULL Kendall Mayteh Anthony As Courier Companies, Inc Charles Bucket Charles Bucket Charles Bucket Charles Bucket Charles Bucket Charles Bucket Charles Bucket Charles Bucket Charles Bucket Charles Bucket Charles Rurket Invoice Total 17.50 NULL NULL City Of Fresno NULL Federal Express Corporation 10.00 Federal Express Corporation 10.00 Federal Express Corporation10.00 Federal Express Corporation 13.75 Federal Express Corporation 15.50 Federal Express Corporation 22.57 Federal Express Corporation 23.50 Federal Express Corporation 26.25 Federal Express Corporation 26.75 Federal Express Corporation 27.00 Federal Fynress ornnratinn 2n 75 54 result rows returned; (only a subset of the result set shown in the image above) 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: Q. terms description vendor state vendor name Net due 20 days NJ Net due 30 days NC Net due 30 days NJ Net due 30 days NJ Net due 30 days NV Net due 30 days NY Net due 30 days NY Net due 30 days NY Net due 60 days NJ Net due 60 days NV Simon Direct Inc Baker &Taylor Books Rich Advertising RR Bowker United Parcel Service The Mailers Guide Co Venture Communications Int 38 American Booksellers Assoc 61 Newbrige Book Clubs Cahners Publishing Company 100 vendor id 76 47 27 32 122 60 10 result rows returned