Skip to content
Related Articles

Related Articles

GATE | GATE CS 1999 | Question 70

View Discussion
Improve Article
Save Article
  • Last Updated : 10 Oct, 2017
View Discussion
Improve Article
Save Article

[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

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!