Database Management problems
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.19