USE MYSQL DATABASE

**Provide Screenshot and explanation on each number

Use the table below and create a program for the following problems:

EMPLOYEE(EmpNo, Sname, JobLevel, Status, DateHired, Salary, EmpAddress). (Please create the table and populate it for your test data for these exercises. Joblevel values could be MGR-manager, RF-Rank and file, S-Supervisor Status values could be R- regular, P-probationary, C-contractual)

1. List the records of employees whose salary is the same as employee whose empno is 11111

2. List the names of employees whose salary is greater than the minimum salary

3. List the names of the employees who have the highest salaries

4. Create another table called Regular_Emp, with the same attributes except for status REGULAR_EMP(EmpNo, Sname, JobLevel, DateHired, Salary, EmpAddress

4.1 Copy all records from Employee table to Regular_Emp table if the status is =R This will effectively store in Regular_Emp table all records of regular employees

5. List all records of employees whose salary is less than the average salary of all employees