Write an UPDATE statement that modifies the invoice you added in exercise 4. This statement should change the credit_total column so it's 10% of the invoice_total column, and it should change the payment_total column so the sum of the payment_total and credit_total columns are equal to the invoice_total column.

Question

lettymartinez285 lettymartinez285

12-06-2020
Computers and Technology

contestada

Write an UPDATE statement that modifies the invoice you added in exercise 4. This statement should change the credit_total column so it's 10% of the invoice_total column, and it should change the payment_total column so the sum of the payment_total and credit_total columns are equal to the invoice_total column.

Respuesta :

Otras preguntas

let f(x)=x+8 and g(x)=x^2 -6x-7. find f(g(2))

Six nickels is what percent of one dollar? What percent of $2.00 would it be? Please help.

Choose the right variant 1 This book will take to years to write. A. After two years I'll write this book B. In two years time I'll have written this book C . A

Lim[(sqrt(cos(2x))-cubicrootof(cos(x))]/arctg(x^2) when x->0

what value of a makes the equation true? 9a+2=4a-18

Is velocity related to momentum

Why are chloroplasts absent in epidermal cells ?

7.25 times 8 1/2= what?

Which choice is equivalent to the expression below? 5x sqrt 2 - 2 sqrt 2 + 2x sqrt 2 A. 7x sqrt 2 - 2 sqrt 2 B. 2x^2 sqrt 2 C. 3x sqrt 2 D. 7x^2 sqrt 2

jeancarlolopez1990 jeancarlolopez1990 · Answer 1 · 2020-06-13T14:46:32+02:00

jeancarlolopez1990 jeancarlolopez1990

13-06-2020

UPDATE invoicesSET credit_total = invoice_total * 0.1, payment_total = invoice_total - credit_totalWHERE invoice_id = 115

Answer Link

jayilych4real jayilych4real · Answer 2 · 2022-06-21T20:47:10+02:00

The UPDATE statement that modifies the invoice is:

UPDATE invoices
SET credit_total = invoice_total * 0.1, payment_total = invoice_total - credit_total
WHERE invoice_id = 115

What is SQL?

This is an acronym that means Structured Query Language and is used to create and update databases.

From the complete information, there is an invoice and we are required to update the database and increase the total credit column, payment total, and credit total columns. The UPDATE statement is given above.