/*10. Write a query to create a view that shows the number of the salesman in each city.*/
CREATE VIEW citynum  
AS SELECT city, COUNT (DISTINCT salesman_id)  
FROM salesman  
GROUP BY city;