تحليل بيانات موظفين

تم استخراج هذه البيانات عند طلب صاحب العمل الاجابه عن الاساله عن الاتى:

1- Total Employees in Comapny

2-Total Employees in each deprtment

3_Total Employees in each Location-

4_Employees who joined before 1991

5_calculate the average salary of employees who work as analysts

6_Employees whose commissions exceed their salaries

7_Employees whose salaries exceed 3000 after receiving a 25% salary increase

8_Identify employees with more than 27 years of experience

9_Day Rate for each employee