/*2. Write a query to create a view for all salesmen with columns salesman_id, name and city.*/
    CREATE VIEW salesown  
     AS SELECT salesman_id, name, city  
     FROM salesman;