Show a list that shows the name, job, and the department name for each employee hired before 1983.

 

For all the employees working in Dallas, list the name of each one and the number of years he has been employed by the company.

Find the number of employees of all the departments located in DALLAS

Find all managers whose salary is more than 200

The company just started a new marketing department in Chicago.

The department ID is 50. Insert a new record into the database.

Give those employees 100 dollars of commission if they never received one before.

Give an employee 8% salary increases if he or she is hired before 1981 and has salary less than 1500.

Find the minimum salary of each department from EMP.

Find the number of employees of all the departments located in DALLAS.