Let me know if these are those questions.
A. Provide a list all of the Customer ID, Customer Names, and States and sort the list in alphabetical order by Customer Name.
B. Provide a list of all of the Customer ID, Customer Names, and States, and sort the list by state with the Customer Names in alphabetical order within each state.
C. List the customers showing the Customer ID, Customer Name, address, and sales rep name in alphabetical order by customer name
D. Which employees have not completed course ID = 90? Hint: name of employee only, and the best way to determine this is by having a subselect statement to determine the EmployeeIDs that have completed CourseID 90, and then have a the select statement use the output of the subselect to determine which of all of the employees are not in the list provided by the subselect.
E. How many sales reps does PSC have? Hint: I want to know how many, not who they are. Also, realize that all sales reps are employees, but not all employees are sales reps. Also, keep in mind that being a sales rep does not mean that they have actually sold anything.
F. List all of the sales reps by name sorted by largest commission rate first Hint: show name and sales commission rate
G. Who is the manager of the sales reps? Hint: name of the manger only.
H. List the employee names of those that report directly to the manager of the sales reps. Hint: Your SQL statement will need to determine the manager first before it can determine the employees tha