Show a list that shows the name, job, and the department name for each employee hired before
Question:
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.
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill