Consider the following relational schema: employee(empId,empName,empDept)…

GATE · 2014 · CS · Set 3 · Computer Science & IT

Consider the following relational schema:

employee(empId,empName,empDept)
customer(custId,custName,salesRepId,rating)

salesRepId is a foreign key referring to empId of the employee relation. Assume that each employee makes a sale to at least one customer. What does the following query return?

SELECT empName
FROM employee E
WHERE NOT EXISTS (SELECT custId
                  FROM customer C
                  WHERE C.salesRepId = E.empId
                  AND C.rating <> 'GOOD');
  1. A.

    Names of all the employees with at least one of their customers having a ‘GOOD’ rating. 

  2. B.

    Names of all the employees with at most one of their customers having a 'GOOD' rating.

  3. C.

    Names of all the employees with none of their customers having a 'GOOD' rating.

  4. D.

    Names of all the employees with all their customers having a 'GOOD' rating.

Attempted by 187 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…