I need help with the following problem. I need to write a SQL query to show the names and salary of salespeople who have two or more orders. First using a join query and then writing the query using a sub query.

SALESPERSON: name, percent_of_quota, salary

ORDER: number, cust_name, salesperson_name, amount

CUSTOMER: name, city, industry_type

sounds like homework

you need to show us what you have done on your own so far, and where you think it might need improvement

we won't just write it for you