Question: Depending on the below schema answer all the question: EMPLOYEE Bdate Sex Sulay Super Dee DEPARTMENT Dname Doumber Mge_n Mgr_start_date Frame Mint San Address DEPT
Depending on the below schema answer all the question: EMPLOYEE Bdate Sex Sulay Super Dee DEPARTMENT Dname Doumber Mge_n Mgr_start_date Frame Mint San Address DEPT LOCATIONS Dnumber Dlocation PROJECT Phame Pumber Plocation Drum WORKS ON Esan Pro Hours DEPENDENT Ess Dependent name Sex Bdate Relationship 1) Write appropriate query to find the number of employees who have supervisor? 2) Retrieve all information for female employee, order the result in ascending order according to salary column. 3) Retrieve project name and department name for each project assigned to specific department. 4) Retrieve the first name for employees who have salary same as Sami's salary. Good Luck
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
