Use The E-R DIAGRAM for the questions.1) determine which employees have the same job title and manager as Jonathon Taylor. Don't include Jonathon Taylor in the results. 2). calculate the earliest possible retirement date for each employee based on the rule that they must have been employed for 20 years .Display the retirement date in the following format: April 7,2009. sort the results in ascending order by retirement date. Display the employee's first name ,last name ,hire date & retirement date. 3) Display the first name, last name and hire dates that have the earliest hire date for each department. display the salaries as currency values and the hire dates in the format xx/xx/xxxx .sort the results by department name.
Recently Asked Questions
- I need help with 2 questions 6) You are studying several populations of pronghorn antelope. Juvenile survival is affected by body size; large individuals are
- A die is rolled five times and the number of fours that come up is tallied. find the probability of getting the given result. Exactly three fours.
- Please refer to the attachment to answer this question. This question was created from Review for Exam 1.