GATE | GATE CS 1999 | Question 70

[5 Marks question]

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. 100,000.


Answer:

Explanation:

Quiz of this Question
Please comment below if you find anything wrong in the above post