Find the first name, last name, and salary of all employees who have the highest salary. (1.5
Question:
Find the first name, last name, and salary of all employees who have the highest salary. (1.5 point) Query Text: Query Output: 5) Find the first name, last name, and salary of all employees who have 3 dependents.(1.5 point) Query Text: Query Output: 7) Show how can you insert a new row to the DEPT_LOCATIONS table using the following details: (1 point) Dnumber=1 DIocation=Bradford Include the insert command and a screen shot of the DEPT_LOCATIONS table showing the new row. 8) Show how can you raise the salaries of all employers in department 5 by 2%. Include the update command and a screen shot of the EMPLOYEE table but only for the employees in department 5 to make sure that the salaries have been increased by 2%. (1.5 point)
Fundamentals of Database Systems
ISBN: 978-0136086208
6th edition
Authors: Ramez Elmasri, Shamkant Navathe