What if you wanted to find out the names of the employees that were hired after Susan
Question:
What if you wanted to find out the names of the employees that were hired after Susan Marvis? Once you know her hire date, then you can select those employees whose hire dates are after her.
Make a query to return all those employees who have a salary greater than that of Loureen Anasthasia and are in the same department as Susan Marvis.
Make a query to return all those employees who have the same job id as Susan Mavris and were hired after Mavris.
Make a query to return a list of department id's and average salaries where the department's average salary is greater than Sherly Naz.
Return the department ID and minimum salary of all employees, grouped by department ID, having a minimum salary greater than the minimum salary of those employees whose department ID is not equal to 50.
Find the last names of all employees whose salaries are the same as the minimum salary for any department.
The goal of the following query is to display the minimum salary for each department whose minimum salary is less than the lowest salary of the employees in department 50. However, the subquery does not execute because it has five errors. Find them, correct them, and run the query.
SELECT department_id
FROM tbl_employees
WHERE MIN(salary) HAVING MIN(salary) >
GROUP BY department_id
SELECT MIN(salary)
WHERE department_id < 50;
Make a pair-wise subquery listing the last_name, first_name, department_id, and manager_id for all employees that have the same department_ id and manager_id as employee 114. Include employee 114 from the result set.
Project Management The Managerial Process
ISBN: 9781260570434
8th Edition
Authors: Eric W Larson, Clifford F. Gray