Ask a Question
  
  
  
Top Posters
Since Sunday
24
15
11
10
9
9
9
8
8
7
7
7
New Topic  
wrote...
Posts: 29
Rep: 0 0
6 days 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';
Source  Download Study Guide
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 2 times
2 Replies
Replies
Answer verified by a subject expert
wrote...
Posts: 26
Rep: 6 0
6 days ago
Sign in or Sign up in seconds to unlock everything on Biology Forums.
UPDATE CUSTOMER
SET Balance = 450
WHERE CustName = 'Gonzales';
1
Related Topics
wrote...
6 days ago
You make an excellent tutor!
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  144 People Browsing
 122 Signed Up Today
Related Images
 7213
 2860
 118
Your Opinion
Who's your favorite biologist?
Votes: 13