Consider the set of relations EMP(Employee-no, Dept-no, Employee-name, Salary)…
PYQ GATE 1999
Consider the set of relations
EMP(Employee-no, Dept-no, Employee-name, Salary)
DEPT(Dept-no, Dept-name, Location)Write an SQL query to:
(a) Find all employee names who work in departments located at "Calcutta" and whose salary is greater than Rs. 50,000.
(b) Calculate, for each department number, the number of employees with a salary greater than Rs. 1,00,000.
Attempted by 1 students.
Sign up free to check your answer
Sign up freeLoading lesson…

