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 free

Explore the full course: Zero To Hero

Loading lesson…