Create and execute the query that returns the vendor names and…

Question Answered step-by-step Create and execute the query that returns the vendor names and… Create and execute the query that returns the vendor names and THEIR Total Invoiced Amount (Hint: invoice_total per vendor) ONLY for those vendors whose Total Invoiced Amount is greater than 5000$ and the result set should be sorted with respect to Vendor names alphabetically as shown in the screenshot below.  [schema: ap]The query would return only 6 rows as shown hereImage transcription textvendor_name Invoice Total Bertelsmann Industry Sves. Inc 6940.25 Data Reproductions Corp 21927.31 DigitalDreamworks 7125.34 Malloy Lithographing Inc 119892.41 United Parcel Service 23177.96 Zylka Design 6940.25… Show more  Computer Science Engineering & Technology MYSQL COMP 1168 Share QuestionEmailCopy link Comments (0)