View the step-by-step solution to:

E-R Diagram below for the questions.find which employees have the same job title and manager as Jonathon Taylor.

E-R Diagram below for the questions. 1).find which employees have the same job title and manager as Jonathon Taylor. 2). calculate the earliest possible retirement date for each employee based on the rule that they must have been employed for 20 years. , sort the results in ascending order by retirement date . Display the employees' 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. 4) Display the name, along with the number of employees for all departments that have less than 3 employees. sort the results by department name. 5) Display the names of departments along with their aggregate and average salary, whose employees have an average salary less than the overall company average salary. Display the aggregate and average salaries as a currency values. sort the results by average salary. 6) Display each employee that has a salary less than the average salary for his department, display the employees ' s full name, along with their salary and department ' s average salary as currency values. sort the results by department name. 7) Display the name of all employees that were hired in 1998 and work in shipping department. sort the results by employee hire date in descending order. 8) Display the Id,name,and assigned department name of any employee that does not manage any employees. sort the results by their staff ID.qa_attachment_1543840203906.jpg

qa_attachment_1543840203906.jpg

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question