Top Posters
Since Sunday
a
5
k
5
c
5
B
5
l
5
C
4
s
4
a
4
t
4
i
4
r
4
r
4
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
sophiegiu sophiegiu
wrote...
Go to Answer
Posts: 294
Rep: 0 0
5 years ago
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
SalesRepNoRepNameHireDate
654Jones01/02/2005
734Smith02/03/2007
345Chen01/25/2018
434Johnson11/23/2004

CUSTOMER
CustNoCustNameBalanceSalesRepNo
9870Winston500345
8590Gonzales350434
7840Harris800654
4870Miles100345


• 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

Database Processing: Fundamentals, Design, and Implementation


Edition: 15th
Authors:
Read 101 times
1 Reply
Replies
Answer verified by a subject expert
dickdick
wrote...
#1
Posts: 172
Rep: 156 0
5 years ago
Sign in or Sign up in seconds to unlock everything for free
More solutions for this book are available here

Related Topics

sophiegiu Author
wrote...

5 years ago
Good timing, thanks!
Shuqin
wrote...

Yesterday
Smart ... Thanks!
Jodias
wrote...

2 hours ago
Brilliant ツ
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1332 People Browsing
 110 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 4428
  
 8950
  
 640
Your Opinion
Which industry do you think artificial intelligence (AI) will impact the most?
Votes: 352
Previous poll results: Do you believe in global warming?