Question: PLEASE HELP ME WITH THESE MYSQL CODE 1. Create and execute a query that returns the Vendors names, Full names of their contact personnel, their

PLEASE HELP ME WITH THESE MYSQL CODE

PLEASE HELP ME WITH THESE MYSQL CODE 1. CreatePLEASE HELP ME WITH THESE MYSQL CODE 1. Create

1. Create and execute a query that returns the Vendors names, Full names of their contact personnel, their invoice numbers, and term description details ordered alphabetically with respect to vendor names, as shown in the screenshot below. [schema: ap] The query would return 48 rows and the first few are shown here vendor_name VendorContact Person invoice_number terms_description Abbev Office Furnishinas Revnaldo. Suscipe 203339-13 Net due 20 davs Federal Express Corporation Charles. Bucket 4-314-3057 Net due 30 days Federal Express Corporation Charles. Bucket 963253269 Net due 30 davs Federal Express Corporation Charles. Bucket 963253267 Net due 30 davs Federal Express Corporation Charles. Bucket 263253253 Net due 30 days Federal Express Corporation Charles. Bucket 963253254 Net due 30 days Federal Express Corporation Charles. Bucket 43966316 Net due 30 davs Federal Express Corporation Charles. Bucket 7548906-20 Net due 30 davs Federal Express Corporation Charles. Bucket 963253248 Net due 30 days Federal Express Corporation Charles, Bucket 263253265 Net due 30 days Federal Express Corporation Charles. Bucket 963253258 Net due 30 days 2. Create and execute a query that returns vendors' and their invoice numbers for those vendors who do not have any invoices ordered alphabetically with respect to vendor names, as shown in the screenshot below. (schema: ap] The query would return 88 rows and the first few are shown here invoice_number NULL NULL NULL NULL vendor_name American Booksellers Assoc American Express ASC Sians Ascom Hasler Mailina Systems AT&T Aztek Label Baker & Tavlor Books BFI Industries Bil Jones Bill Marvin Electric Inc NULL HULL NULL NULL NULL NULL 3. Create and execute a query that returns the customers first names, item id's for all items that were ordered equal or more than 2 in quantity, arranged alphabetically with respect to customers first names, as shown in the screenshot below. (schema: om] The query would return 4 rows exactly as shown here customer_first_name item_id QuantityOrdered Erick 6 2 Karina 7 4 Korah 1 2 Korah 7 2 NNN

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!