Write an SQL query to display all salesmen and customer located in Chennai.

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 display all salesmen and customer located in Chennai.

Answer :-

Select name from Salesman where city = “Chennai” ;