Aggregate Functions and Group - SQL Practice Queries

Demonstrate mastery of Aggregate functions and group by.

Use the Murach AP database to answer the following scenarios. Turn in 1 .sql file with all queries in the single file.

1. I want a result set that will show me the invoices grouped by the vendor.

2. I want a result set that will show me the vendors and the total amount they have been invoiced in order from least amount invoiced to most amount invoiced.

3. I want a result set that shows the vendors and the total amount they have been invoiced that have a total amount greater than $2000.00.

Need Full code please. Here are the tables: let me know if anything is missing

dbo.ContactUpdates dbo.GLAccounts dbo.InvoiceArchive dbo.InvoiceLineltems ES dboInvoices dbo.Terms dbo.Vendors