SELECT customer.Name, customer.city, salesman.Name
FROM customer
LEFT JOIN salesman on customer.Salesman_id = salesman.Id
WHERE salesman.commission >= 0.12 AND salesman.commission <= 0.14