Homework Help is Here – Start Your Trial Now!
Engineering
Data Structures and Algorithms
5. Show the names and salaries of all salespeople who do not have an order with Abernathy Construction, in ascending order of salary. Number 100 200 300 400 500 600 700 ORDER Name Abel Baker Jones Murphy Zenith Kobad SALESPERSON CustName Abernathy Construction Abernathy Construction Manchester Lumber Amalgamated Housing Abernathy Construction Tri-City Builders Manchester Lumber Name CUSTOMER Age 63 38 26 42 59 27 Abernathy Construction Manchester Lumber Tri-City Builders Amalgamated Housing Salary 120,000 42,000 36,000 50,000 118,000 34,000 SalespersonName Amount Zenith 560 Jones 1800 480 2500 6000 Abel Abel Murphy Abel Jones City Willow Manchester Memphis Memphis 700 150 IndustryType B F B B 9. Show the names and salaries of all salespeople who do not have an order with Abernathy Construction, in descending order of salary. 10. Compute the number of orders.

5. Show the names and salaries of all salespeople who do not have an order with Abernathy Construction, in ascending order of salary. Number 100 200 300 400 500 600 700 ORDER Name Abel Baker Jones Murphy Zenith Kobad SALESPERSON CustName Abernathy Construction Abernathy Construction Manchester Lumber Amalgamated Housing Abernathy Construction Tri-City Builders Manchester Lumber Name CUSTOMER Age 63 38 26 42 59 27 Abernathy Construction Manchester Lumber Tri-City Builders Amalgamated Housing Salary 120,000 42,000 36,000 50,000 118,000 34,000 SalespersonName Amount Zenith 560 Jones 1800 480 2500 6000 Abel Abel Murphy Abel Jones City Willow Manchester Memphis Memphis 700 150 IndustryType B F B B 9. Show the names and salaries of all salespeople who do not have an order with Abernathy Construction, in descending order of salary. 10. Compute the number of orders.

icon
Related questions
Question
5. Show the names and salaries of all salespeople who do not have an order with Abernathy Construction, in ascending order of salary. Number 100 200 300 400 500 600 700 ORDER Name Abel Baker Jones Murphy Zenith Kobad CUSTOMER SALESPERSON CustName Name Abernathy Construction Abernathy Construction Manchester Lumber Amalgamated Housing Abernathy Construction Tri-City Builders Manchester Lumber Abernathy Construction Manchester Lumber Tri-City Builders Amalgamated Housing Age 63 38 26 42 59 27 11. Compute the number of different customers who have an order. 12. Compute the average age of a salesperson. 13. Show the name of the oldest salesperson. Salary 120,000 42,000 36,000 50,000 118,000 34,000 SalespersonName Amount Zenith 560 Jones 1800 Abel 480 2500 Abel Murphy 6000 700 Abel Jones 150 City Willow Manchester Memphis Memphis IndustryType B F B B 9. Show the names and salaries of all salespeople who do not have an order with Abernathy Construction, in descending order of salary. 10. Compute the number of orders. 14. Compute the number of orders for each salesperson. 15. Compute the number of orders for each salesperson, considering only orders for an amount exceeding $500. 16. Show the names and ages of salespeople who have an order with Abernathy Construction, in descending order of age (use a subquery). 17. Show the names and ages of salespeople who have an order with Abernathy Construction, in descending order of age (use a join). 18. Show the age of salespeople who have an order with a customer in Memphis (use a subquery). 19. Show the age of salespeople who have an order with a customer in Memphis (use a join). 20. Show the industry type and ages of the salespeople of all orders for companies in Memphis. 21. Show the names of salespeople who have two or more orders.
Transcribed Image Text:5. Show the names and salaries of all salespeople who do not have an order with Abernathy Construction, in ascending order of salary. Number 100 200 300 400 500 600 700 ORDER Name Abel Baker Jones Murphy Zenith Kobad CUSTOMER SALESPERSON CustName Name Abernathy Construction Abernathy Construction Manchester Lumber Amalgamated Housing Abernathy Construction Tri-City Builders Manchester Lumber Abernathy Construction Manchester Lumber Tri-City Builders Amalgamated Housing Age 63 38 26 42 59 27 11. Compute the number of different customers who have an order. 12. Compute the average age of a salesperson. 13. Show the name of the oldest salesperson. Salary 120,000 42,000 36,000 50,000 118,000 34,000 SalespersonName Amount Zenith 560 Jones 1800 Abel 480 2500 Abel Murphy 6000 700 Abel Jones 150 City Willow Manchester Memphis Memphis IndustryType B F B B 9. Show the names and salaries of all salespeople who do not have an order with Abernathy Construction, in descending order of salary. 10. Compute the number of orders. 14. Compute the number of orders for each salesperson. 15. Compute the number of orders for each salesperson, considering only orders for an amount exceeding $500. 16. Show the names and ages of salespeople who have an order with Abernathy Construction, in descending order of age (use a subquery). 17. Show the names and ages of salespeople who have an order with Abernathy Construction, in descending order of age (use a join). 18. Show the age of salespeople who have an order with a customer in Memphis (use a subquery). 19. Show the age of salespeople who have an order with a customer in Memphis (use a join). 20. Show the industry type and ages of the salespeople of all orders for companies in Memphis. 21. Show the names of salespeople who have two or more orders.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer