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, '31-AUG-08'). What's wrong with this?

Answer in explanation

Explanation:

In the table to fill, there are 7 attributes aside the index column to fill, making a total of 8 columns to fill.

Now, in the values part of the query, it can be seen that we only have inputs for 7 out of the 8 columns to fill. Hence, we can say that the number of columns to fill with the different values is incomplete and there is a need to check the values side of the query to ensure that complete information is supplied.

To be properly specific, considering the type of data to be inputed, there is a date stamp format to be filled in both the invoice_date and invoice_due_date columns. But checking the values, we can see we only have one date format. Hence, the query is expected to return an error

There are few values in the list. So, this insert statement will not be executed.