Q22-a

MCQMarks unknown

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 employees 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.

Loading…