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?

Question

Kody

Business

1 December, 21:49

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?

+3

Answers (1)

Know the Answer?

Nguyen · Answer 1

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.