1. Generate database queries to answer these questions.

1. Create a query to get a listing of the name, commission rate, and hire date of all salespersons who sell to commercial customers. Sort the result in order from the first hired to the most recently hired salesperson. Save the query as Query 1 - Hire Date. (10 Points)

Name	Hire date	Commission Rate	Customer category

2. Create a query to get a listing of the names and commission rates of all salespersons in the eastern region or western regions sorted alphabetically. Save the query as Query 2 Eastern & Western Salespersons. (10 points)

Name	Commission rate	Region

3. Prepare a list showing the number of salespersons receiving each commission rate and total sales in that rate. Save query as Query 3 Number of Salespersons by Commission Rate. Use the field property option to set the captions and percents as follows. Print the results. (10 points)

Commission rate	Total Sales
1%
2%
3%
4%
5%
6%

4. Create a query to calculate the Commission Pay for each salesperson. (Commission Pay = Sales Amount * Commission rate). Include Emp_Name and Commission Pay in the query. Save Query as Query 3 Commission Payment and print the results. (10 points)

Emp Name	Commission Payment