I need help with these queries! I keep getting syntax errors I need hep with d,e&f. thank you!

what I need but can't seem to duplicate:

a. Go to the Relationships screen and connect the five tables, enforcing referential integrity. b. Calculate the total sales for each customer. Include CustomerlD and CompanyName from the Customer table and the calculated sale amount from the Sale_Amount_Calculation query. Name the query Total_Customer_Sales. 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 rsmith. 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. Required: e. Which customer had the highest average sales amount? What specifically was their average amount? f. Which employee had the highest earned commission? What specifically was their commission amount? Complete this question by entering your answers in the tabs below. e. Which customer had the highest average sales amount? What specifically was their average amount? (Input your answers exactly as they appear in Access, with 2 decimals when required.) Employee Email Gerierato: Sale Ambunt Salculation Sale-Month Total Sustomer Jales Expression Builder Enter an Expression to define the calculated query field: (Examples of expressions indude [field1] +[ field2] and [field1] 1 Clews Expression Builder Enter an Expression to define the calculated query field: (Examples of expressions indude [field1] +[ field2] and [field1] Expr 1 InvoiceDate InvoiceID a. Go to the Relationships screen and connect the five tables, enforcing referential integrity. b. Calculate the total sales for each customer. Include CustomerlD and CompanyName from the Customer table and the calculated sale amount from the Sale_Amount_Calculation query. Name the query Total_Customer_Sales. 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 rsmith. 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. Required: e. Which customer had the highest average sales amount? What specifically was their average amount? f. Which employee had the highest earned commission? What specifically was their commission amount? Complete this question by entering your answers in the tabs below. e. Which customer had the highest average sales amount? What specifically was their average amount? (Input your answers exactly as they appear in Access, with 2 decimals when required.) Employee Email Gerierato: Sale Ambunt Salculation Sale-Month Total Sustomer Jales Expression Builder Enter an Expression to define the calculated query field: (Examples of expressions indude [field1] +[ field2] and [field1] 1 Clews Expression Builder Enter an Expression to define the calculated query field: (Examples of expressions indude [field1] +[ field2] and [field1] Expr 1 InvoiceDate InvoiceID