Recent Posts • Latest Topics • Unanswered Questions

Based on the tables below, which of the following commands in ANSI SQL would return only the name of ...

sophiegiu

wrote...

Go to Answer

Posts: 294

Rep:

5 years ago

Based on the tables below, which of the following commands in ANSI SQL would return only the name of ...

Based on the tables below, which of the following commands in ANSI SQL would return only the name of the sales representative and the name of the customer for each customer that has a balance greater than 400?

GENERAL SALES DATABASE:

SALESREP

SalesRepNo	RepName	HireDate
654	Jones	01/02/2005
734	Smith	02/03/2007
345	Chen	01/25/2018
434	Johnson	11/23/2004

CUSTOMER

CustNo	CustName	Balance	SalesRepNo
9870	Winston	500	345
8590	Gonzales	350	434
7840	Harris	800	654
4870	Miles	100	345

• SELECT *
FROM SALESREP, CUSTOMER
WHERE Balance > 400;

• SELECT DISTINCT RepName, CustName
FROM SALESREP, CUSTOMER
WHERE Balance > 400;

• SELECT *
FROM SALESREP, CUSTOMER
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo
AND Balance > 400;

• SELECT RepName, CustName
FROM SALESREP, CUSTOMER
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo
AND Balance > 400;

Textbook

Database Processing: Fundamentals, Design, and Implementation

Edition: 15^th

Authors: Kroenke, Auer, Yoder, Vandenberg

Read 100 times

1 Reply

Report

Replies

Answer verified by a subject expert

dick

wrote...

Posts: 172

Rep:

5 years ago

More solutions for this book are available here

1 Vote

michiamoliz

Report

Related Topics

sophiegiu Author

wrote...

5 years ago

You make an excellent tutor!

Hellish Lover

wrote...

Yesterday

Thanks

mikeh209

wrote...

2 hours ago

I appreciate what you did here, answered it right Smiling Face with Open Mouth

New Topic

Quick Reply

Explore

Post your homework questions and get free online help from our incredible volunteers

1182 People Browsing

114 Signed Up Today

Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook

Live Chat

Related Images

346

315

298

Your Opinion

Previous poll results: Does a gender wage gap exist in America?

Bonobos, Chimpanzees, and the 98% DNA Link

Strange Ingredients Lurking in Doritos Chips

The Toxic Skin and Fungi Defense

It's sore throat season, why does my mucus have red spots?

Courses by Biology Forums

Ready to ask a question on Biology Forums? Try it out

Join Our Community

Biology Forums - Study Force is a free online homework help service catered towards college and high school students. Get homework help and answers to your toughest questions in biology, chemistry, physics, mathematics, engineering, accounting, business, humanities, and more. Master your assignments quickly with thousands of step-by-step solutions to countless textbook questions asked and answered by our members. If we don't have your question, don't worry. You can ask any homework question and get expert homework help in as little as two hours.

Our extensive online study community is made up of college and high school students, teachers, professors, parents and subject enthusiasts who contribute to our vast collection of study resources: textbook solutions, study guides, practice tests, practice problems, lecture notes, equation sheets and more. With our help, your homework will never be the same!

Join for free today

How is Biology Forums - Study Force different than tutoring?

Home Search Q & A Board Gallery Resource Library Blog Dictionary Chat	Quick Links Start a Topic Latest Topics Unanswered Questions Courses Study Tools Browse by Textbook	Social Facebook YouTube Community Stats Who's Online Trending Staff	Help About Us Take the Tour Study Tips Posting Guidelines Terms and Policies Contact Us
Biology Forums - Study Force © 2010-2024 \| Powered by SMF \| SMF © 2015, Simple Machines \| Sitemap Biology-Forums.com is not affiliated with any publisher. Book covers, title and author names appear for reference only.