Write an SQL query to list all the salesmen who have customers with grade 200 or higher.

Consider following tables to answer question:

Salesman (salesman_id, name, city, commission) and
Customer (customer_id, cust_name, city, grade, salesman_id)

Q. Write an SQL query to list all the salesmen who have customers with grade 200 or higher.

Answer :-

Select name from Salesman , customer where Salesman.salesman_id =  customer.salesman_id and grade >= 200 ;