Write and execute a select statement that will return the customer’s name, city, salesman’s number assigned to customer, and the assigned salesman’s last name for customers located in the state of new york.