Assuming that all of the table and column names are spelled correctly, what's wrong with the insert statement that follows?
insert into invoices
(vendor_id, invoice_number, invoice_total, payment_total, credit_total,
terms_id, invoice_date, invoice_due_date)
values
(97, '456789', 8344.50, 0, 0, 1, '2012-08-31')
a. there are too few items in the values list.
b. the column names in the column list are in the wrong sequence.
c. the number of items in the column list doesn't match the number in the values list.
d. there are too many items in the column list.