Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Find the commission percentage and year of hire of salesperson number 186. 2. Retrieve the entire record for salesperson 186. 3. List the salesperson

image text in transcribed
image text in transcribed
1. Find the commission percentage and year of hire of salesperson number 186. 2. Retrieve the entire record for salesperson 186. 3. List the salesperson numbers and salesperson names of those salespersons who have a commission percentage of 10. 4. List the salesperson number and salesperson name of all of the salespersons. 5. List the salesperson numbers, salesperson names, and commission percentages of the salespersons whose commission percentage is less than 12. 6. List the customer numbers and headquarters cities of the customers that have a customer number of at least 1700. 7. List the customer numbers, customer names, and headquarters cities of the customers that are headquartered in New York and that have a customer number higher than 1500. 8. List the customer numbers, customer names, and headquarters cities of the customers that are headquartered in New York or that have a customer number higher than 1500. 9. List the salesperson number, salesperson names, and commission percentage of the salespersons who have a commission percentage higher than 10. 9. List the salesperson number, salesperson names, and commission percentage of the salespersons who have a commission percentage higher than 10. 10. List the customer numbers, employee names, and employee numbers of the customer employees who are titled as "Sales Manager" or who have a customer number higher than 1500 11. List the customer numbers, customer names, and headquarters cities of the customers that are headquartered in New York or that satisfy the two conditions of having a customer number higher than 1500 and being headquartered in Atlanta. 12. List the customer numbers, sales person numbers, and headquarters cities of the customers and sales person that are headquartered in Los Angeles or that satisfy the two conditions of having a customer number higher than 1000 and being headquartered in Chicago 13. Find the customer records for those customers whose customer numbers are between 1000 and 1700. 14. Find the customer records for those customers whose names begin with the letter "A" 15. Find the product records for those product names begin with the letter "H". 16. Which cities serve as headquarters cities for General Hardware customers

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Server Query Performance Tuning

Authors: Sajal Dam, Grant Fritchey

4th Edition

1430267429, 9781430267423

More Books

Students also viewed these Databases questions