Title: Based on the tables below, which of the following SQL statements would increase the balance of the ... Post by: Suedyso on Feb 13, 2019 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
CUSTOMER
• 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'; Title: Based on the tables below, which of the following SQL statements would increase the balance of the ... Post by: emr21 on Feb 13, 2019 Content hidden
Title: Based on the tables below, which of the following SQL statements would increase the balance of the ... Post by: Suedyso on Feb 13, 2019 You make an excellent tutor!
|