1).Select the sales for each Sales Person, from the Sales.Store table where the sales person ID is equal to 279, 281, or 288). Sort by the Sales Person ID, and then by the Business Name (make sure to list Sales Person ID, and Store Name). You should get 199 records.

2).For each Vendor with a credit rating of 2 or higher, list the Vendors Name, Account Number, and Credit Rating. Sort by the credit rating (descending), and then vendor name. You should get 20 records.

3).List the Sales Tax Rate, State Province ID, Tax Type, and Name for all sales tax rates of 7.50 or higher, and with a state province ID greater than 10. Put the list in order of tax rate and then company name. You should get 9 records.

Prepare and execute each of the queries using the "Adventureworks2012" database in SQL Server.