a. Write an INSERT statement that adds these rows to the Invoice_Line_Items table: (All in MySQL) invoice_sequence:
Question:
a. Write an INSERT statement that adds these rows to the Invoice_Line_Items table: (All in MySQL)
invoice_sequence: 1 2
Account_number: 160 527
line_item_amount: $180.23 $254.35
line_item_description: Hard Drive Exchange Server Update
Set the invoice_id column of these two rows to the invoice ID that was generated by MySQL for the invoice you added in exercise 4.
b. 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.
The invoice from #4 (Mentioned above) (Done in MySQL)
invoice_id: The next automatically generated ID
Vendor_id: 32
invoice_number: AX-104-027
invoice_date:8/1/2014
invoice_total:$434.58
payment_total:$0.00
credit_total:$0.00
terms_id: 2
invoice_due_date: 8/31/2014
payment_due: null
Practicing Statistics Guided Investigations for the Second Course
ISBN: 978-0321586018
1st edition
Authors: Shonda Kuiper, Jeff Sklar