Top Posters
Since Sunday
g
3
3
2
J
2
p
2
m
2
h
2
s
2
r
2
d
2
l
2
a
2
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
Suedyso Suedyso
wrote...
Go to Answer
Posts: 371
Rep: 0 0
5 years ago
Based on the tables below, which of the following SQL statements would increase the balance of the Gonzales account by $100 to a total of $450?

GENERAL SALES DATABASE:

SALESREP
SalesRepNoRepNameHireDate
654Jones01/02/2005
734Smith02/03/2007
345Chen01/25/2018
434Johnson11/23/2004

CUSTOMER
CustNoCustNameBalanceSalesRepNo
9870Winston500345
8590Gonzales350434
7840Harris800654
4870Miles100345


• SELECT Gonzales
FROM CUSTOMER
INSERT VALUES PLUS (100) INTO Balance;

• SELECT Gonzales
FROM CUSTOMER
INSERT VALUES (450) INTO Balance;

• INSERT INTO CUSTOMER VALUES (450)
SELECT Balance
WHERE CustName = 'Gonzales';

• UPDATE CUSTOMER
SET Balance = 450
WHERE CustName = 'Gonzales';
Textbook 
Database Processing: Fundamentals, Design, and Implementation

Database Processing: Fundamentals, Design, and Implementation


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

Related Topics

Suedyso Author
wrote...
#2
5 years ago
You make an excellent tutor!
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1119 People Browsing
 113 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 459
  
 190
  
 250
Your Opinion
What's your favorite math subject?
Votes: 293
Previous poll results: What's your favorite coffee beverage?