Depending on the below schema answer all the question: EMPLOYEE Frame Mint Lume Bdate Address San 2012 Bax Salary Supet. Dno DEPARTMENT Drame Drumbor Mgr son Mgr_start date DEPT LOCATIONS Onumber Docation PROJECT Prame Pnumber Plocation Dnum WORKS ON Esan Pro Hours DEPENDENT Esen 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