c$.$ Generate an e$-$mail user name for each employee using the first letter of the employee's first name and the first five letters of the employee's last name, e$.$g$.$ Rod Smith $=>$ ismith. Include EmployeelD,

EmployeeFirstName, and EmployeeLastName in the query. Name the query Employee$\_$Email$\_$Generator.

d$.$ Calculate the total sales for each month.

e$.$ Determine which customer had the highest average sales amount. $($Hint Sort in descending order.$)$

f$.$ Assume the employees earn a $5$ percent commission on sales. Calculate the total commission due to each employee. Use two queries to do these calculations.