Question 18Consider following tables to answer below question :Salesman (salesman_id, name, city, commission ) and

Customer (customer_id, cust_name, city, grade, salesman_id )
Write an SQL query to list all the salesmen who have customers with grade 200 or higher.

Question

Question 18Consider following tables to answer below question :Salesman (salesman_id, name, city, commission ) and

Customer (customer_id, cust_name, city, grade, salesman_id )
Write an SQL query to list all the salesmen who have customers with grade 200 or higher.

Bright Tutorials · Accepted Answer

SELECT s.name
FROM Salesman s, Customer c  
WHERE s.salesman_id = c.salesman_id AND c.grade >= 200;

JOINS and SET Operations — Question 18