Question

When coded in a WHERE clause, which search condition will return invoices when payment_date isn’t null and invoice_total is greater than or equal to $500?

Answer 1

Answer:

Option d is the correct answer, i.e; payment_date IS NOT NULL AND invoice_total >= 500

Explanation:

When coded in a WHERE clause, which search condition will return invoices when payment date isn’t null and invoice total is greater than or equal to $500 then payment_date IS NOT NULL AND invoice_total >= 500 and the remaining options are wrong.

Therefore, the Option with, i.e; payment_date IS NOT NULL AND invoice_total >= 500 is the correct answer.