Write an SQL query to list all the salesmen who do not have customers in DELHI and JAMMU.

Consider following tables to answer questions:

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 do not have customers in 'DELHI' and 'JAMMU'.

Answer :-

Select name from Salesman , customer where Salesman.salesman_id =  customer.salesman_id and not (customer.city in (“DELHI” , “JAMMU”) ) ;