Based on the Table Below, the SQL Statement That Changes

question 4

Multiple Choice

Based on the table below, the SQL statement that changes the address and city of customer 3175, Gregory Adams, to 1337 Parkway Ave and Pembrook, SD, 57462, respectively, is _____________________. Customer table

• A) UPDATE Customer Address = '1337 Parkway Ave', City = 'Pembrook', State = 'SD', Zip = '57462' WHERE FirstName = 'Gregory' AND LastName = 'Adams'
• B) UPDATE Customer SET Address = '1337 Parkway Ave', City = 'Pembrook', State = 'SD', Zip = '57462' WHERE FirstName = 'Gregory' AND LastName = 'Adams'
• C) UPDATE Customer SET Address = '1337 Parkway Ave', City = 'Pembrook', State = 'SD', Zip = '57462' WHERE Name = 'Gregory Adams'
• D) UPDATE Customer SET Address = '1337 Parkway Ave', City = 'Pembrook', State = 'SD', Zip = '57462'

---

Definitions:

Sales Discounts

Sales discounts are reductions in price offered by sellers to encourage buyers to make a purchase, often recorded as a deduction from gross sales.

Contra Revenue Accounts

Accounts on a company's income statement that deduct from gross revenue to arrive at net revenue, reflecting returns, allowances, and discounts.

Sales Revenue

Sales revenue refers to the income received from selling goods or services over a period of time.

Income From Operations

The profit realized from a business's core operating activities, excluding deductions of interest and taxes.