Question
Consider the following Employee Relation. [ F | 20) 2 Im Write SQL Queries for the following: i) Fetch the Dept_ID whose average salary is higher than 4000. ii) Fetch the Dept_ID whose average salary of male employees is higher than 2000. iii) Fetch the Name ofall employees whose Manager_ID is Il’. iv) Fetch the Name ofall employees of Dept_ID as’103′ and their Manager_IDis’l’. Fetch the name, salary, and Dept_ID of employee vi) Fetch the E_ID and Name of employees who are getting salary higher than the salary of employee ‘F’. vii) Fetch the D_ID of employees who are getting salary higher than the salary of employee ‘E’. – Employee . _ [E Name | Dept [1 {a _ LM : | 8 | M [soo; 1 | io | 3 | 1 | tot F_| 2000 — tH] Cet a | F [3007 1 Tm | SQL :
