Database Management problems
Not what you're looking for? Search our solutions OR ask your own Custom question.
Note the table below.
Write an SQL query to show the names and salary of salespeople who have two or more orders. First use a join query and then write the query again using a sub query.
SALESPERSON: name, percent_of_quota, salary
ORDER: number, cust_name, salesperson_name, amount
CUSTOMER: name, city, industry_type
https://brainmass.com/computer-science/databases/database-management-example-problems-12680
Solution Summary
This solution provides an SQL query to show the names and salary of salespeople who have two or more orders.
$2.49