Assuming that all of the table and column names are spelled correctly, what's wrong with the INSERT statement that follows? INSERT INTO ACME$\_$invoices

$($vendor$\_$id$,$ invoice$\_$number, invoice$\_$total, payment$\_$total, credit$\_$total, terms$\_$id$,$ invoice$\_$date, invoice$\_$due$\_$date$)$

VALUES

$(97,\text{'}456789,8344\mathrm{.}50,0,0,1,\text{'}31-$AUG$-08\text{'})$

The number of items in the column list doesn't match the number in the VALUES list.

The column names in the column list are in the wrong sequence.

This is just fine, there is nothing wrong

There are too many items in the column list.