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.

Answer rating: 100% (QA)

To find the names of employees hired after Susan Marvis you first need to know her hire date Once you have that information you can use it to select t... View the full answer