(Solved): Create and execute a query that returns the vendor names and THEIR Total Invoiced Amount (Hint: in ...

Create and execute a 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 here