1. Write the SQL query to retrieve the following information of all employees: a. Employee number b....
Question:
1. Write the SQL query to retrieve the following information of all employees:
a. Employee number
b. Employeelastname
c. Date of hire
d. Jobcode.
The company wants to send a check to their employees as a gift. The amount of the check will be calculated based on the employee's experience. So, for each year of working in the company, they will be paid $30. Write a query to show the employees number, last name, job description (not the job code), years of their experience, and the amount of money that they will be paid.
Write a query to retrieve first and last name of the employees that are manager in any project (EMP_NUM column in project table shows the employee number of the project managers for each project)
Write a query to retrieve Last name of all the employees and the projects that they are assigned to.
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill