Answered step by step
Verified Expert Solution
Question
1 Approved Answer
c . Generate an e - mail user name for each employee using the first letter of the employee's first name and the first five
c Generate an email 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, eg Rod Smith ismith. Include EmployeelD,
EmployeeFirstName, and EmployeeLastName in the query. Name the query EmployeeEmailGenerator.
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 percent commission on sales. Calculate the total commission due to each employee. Use two queries to do these calculations.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started