Write an SQL query to list all the customers whose salesmen have earned a commission of at least 15%

Consider following tables to answer questions 15-20:

Salesman (salesman_id, name, city, commission) and
Customer (customer_id, cust_name, city, grade, salesman_id)

Q. Write an SQL query to list all the customers whose salesmen have earned a commission of at least 15%

Answer :-

Select name from Salesman where commission = “15%”;