Show the names of all salespeople who can earn more than $49,999 and less than $100,000
The questions in this group refer to the following three relations:
SALESPERSON (Name, Age, Salary)
ORDER (Number, Customer Name, Salesperson Name, Amount)
CUSTOMER (Name, City, Industry Type)
SALESPERSON
Name |
Age |
Salary |
Abel |
63 |
120,000 |
Baker |
38 |
42,000 |
Jones |
26 |
36,000 |
Murphy |
42 |
50,000 |
Zenith |
59 |
118,000 |
Kobad |
27 |
34,000 |
ORDER
Number |
CustName |
SalespersonName |
Amount |
100 |
Abernathy Construction |
Zenith |
560 |
200 |
Abernathy Construction |
Jones |
1800 |
300 |
Manchester Lumber |
Abel |
480 |
400 |
Amalgamated Housing |
Abel |
2500 |
500 |
Abernathy Construction |
Murphy |
6000 |
600 |
Tri-City Builders |
Abel |
700 |
700 |
Manchester Lumber |
Jones |
150 |
CUSTOMER
Name |
City |
Industry Type |
Abernathy Construction |
Willow |
B |
Manchester Lumber |
Manchester |
F |
Tri-City Builders |
Memphis |
B |
Amalgamated Housing |
Memphis |
B |
Use the data in those tables and show the SQL statements to display or modify data as indicated in the following questions:
4.Show the names of all salespeople who can earn more than $49,999 and less than $100,000.
5.Show the names and salary of all salespeople who do not have an order with Abernathy Construction, in ascending order of salary.
6.Compute the number of orders.
Step by step
Solved in 2 steps with 1 images