How_to_retrieve_data_from_a_single_table/Exec_4_26.sql

use ap;
select * from invoices
UPDATE invoices 
SET credit_total = invoice_total * 0.1
payement_total = invoice_total - credit_total
WHERE invoice_id = '';