/*20. Write a query to find all the salesmen for whom there are customers that follow them.*/
SELECT *  
FROM salesman   
WHERE city IN  
    (SELECT city  
     FROM customer);