Write an SQL query to display distinct salesman and their cities.

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 display distinct salesman and their cities.

Answer :-

Select distinct name, city from Salesman;