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.
