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.
Recently Asked Questions
- If Baldwin issued 1000 shares of common stock at last year's end price, the effect on the balance sheet would be: cash 2018 2017 cash 23.225 15.4% 31.638 Acct
- According to the symbolic interactionist perspective , why do women in poor nations bear a large number of children ?
- According to Sternberg , the best problem solvers :