53. Create a view that shows all the number of salesman in each city.

CREATE VIEW salesman_city AS
SELECT
    city,
    COUNT(snum) as no_of_salesman
FROM
    salesman
GROUP BY
    city;

Output: