Question: Depending on the below schema answer all the question: EMPLOYEE Mini Lame San Bdate Address Sex Salary Superman Do DEPARTMENT Drame Drumber Mgr son Mor_start

 Depending on the below schema answer all the question: EMPLOYEE Mini

Depending on the below schema answer all the question: EMPLOYEE Mini Lame San Bdate Address Sex Salary Superman Do DEPARTMENT Drame Drumber Mgr son Mor_start date DEPT LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation Dnum WORKS ON Pro Esan Hour DEPENDENT Esan Dependent name Sex date 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 G

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!