using mysql. and include screenshot

Scenario The two tables from 'In-Class Exercise 1: Querying Data' certainly help us to improve our understanding about products and customers and their contributions to business success. Now, we would like to improve our understanding about another important element of business, which is emplovees. We especially want to evaluate how each employee has been contributing to the business success measured, for example, in terms of employee's contribution to sales revenue. Employees are assigned to customers as sales representatives and are responsible for promoting sales by providing services to the assigned customers. In this regard, we would like to prepare a list of top 10 employees, which looks similar to the tables from 'In-Class Exercise 1: Querying Data.' First, think about how you are going to measure the contributions of emplovees and choose the columns (at least 4) that will be included in the top 10 list of yours. You need to take a close look at the tables in the sample database as well as the database schema available from 'MIS2022_LectureNote_Week5 7.pdf.' Once you have done all these, do the following (1. 4.): 1. [Explanations about the list (i.e., table) of your choice] ( 15 points) Explain how you are going to measure the contributions of employees and explain the columns that will be included in the list. Also, briefly explain how knowledge from the list is expected to help you to come up with a plan to motivate employees to keep contributing to business success in the future. 2. [SQL scripts with explanations] (50 points) Prepare a SELECT statement to produce the list from 1. above, and explain the key steps in your SELECT statement. 3. [Resulting table] (20 points) Present the result of the SQL scripts from 2. above. [Tips] First, export the resulting tables in the MySQL Workbench to a csv file. Then, open the csv files in Excel and copy and paste the table in your word file. You may edit borders of the table if you like. 4. [Discussions] (15 points) Briefly explain what you learn from the list presented in 3. above. Does the knowledge presented in the list meet your expectations that you stated in 1 . above and have some useful implications for the plan to motivate the employees? Would you suggest any further analysis using the list to extract further insights from the knowledge presented in the list? Scenario The two tables from 'In-Class Exercise 1: Querying Data' certainly help us to improve our understanding about products and customers and their contributions to business success. Now, we would like to improve our understanding about another important element of business, which is emplovees. We especially want to evaluate how each employee has been contributing to the business success measured, for example, in terms of employee's contribution to sales revenue. Employees are assigned to customers as sales representatives and are responsible for promoting sales by providing services to the assigned customers. In this regard, we would like to prepare a list of top 10 employees, which looks similar to the tables from 'In-Class Exercise 1: Querying Data.' First, think about how you are going to measure the contributions of emplovees and choose the columns (at least 4) that will be included in the top 10 list of yours. You need to take a close look at the tables in the sample database as well as the database schema available from 'MIS2022_LectureNote_Week5 7.pdf.' Once you have done all these, do the following (1. 4.): 1. [Explanations about the list (i.e., table) of your choice] ( 15 points) Explain how you are going to measure the contributions of employees and explain the columns that will be included in the list. Also, briefly explain how knowledge from the list is expected to help you to come up with a plan to motivate employees to keep contributing to business success in the future. 2. [SQL scripts with explanations] (50 points) Prepare a SELECT statement to produce the list from 1. above, and explain the key steps in your SELECT statement. 3. [Resulting table] (20 points) Present the result of the SQL scripts from 2. above. [Tips] First, export the resulting tables in the MySQL Workbench to a csv file. Then, open the csv files in Excel and copy and paste the table in your word file. You may edit borders of the table if you like. 4. [Discussions] (15 points) Briefly explain what you learn from the list presented in 3. above. Does the knowledge presented in the list meet your expectations that you stated in 1 . above and have some useful implications for the plan to motivate the employees? Would you suggest any further analysis using the list to extract further insights from the knowledge presented in the list