Write an SQL query to list all the salesmen who have customers with grade 200 from city JAMMU.

Consider following tables to answer questions 15-20:

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 from city 'JAMMU'.

Answer :-

Select name from Salesman , customer where Salesman.salesman_id = customer.salesman_id and grade >= 200 and city = “JAMMU” ;