USE MYSQL DATABASE

**Provide Screenshot and explanation on each number

tables

EMPLOYEE(EmpNo, EName, JobLevel, DateHired, EmpAddress) Employee Master File

EMPEVALUATION(EmpNo, Rating, RatingPeriod) Table of all over-all ratings of employee for all rating periods

Use join, intersect, union, or except for the following problems: 1.Display the employee number, name, and his ratings for the different rating periods.

2. Display the employee number, name, and address of employees who got 90 and above in any of the rating periods.

3. Display the employee number, name, and address of employees who got between 70-75 during FY2018 rating period.

4. Create two solutions/programs for this problem. For the first, use Intersect, for the second, use Join. Display only the employee number of those who were hired after 12/31/2018 whose rating is 90 and above for rating period FY2019

5. Display all employee numbers who did not get a rating of 90 in any of the rating periods.