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

Business

Helen

15 July, 00:56

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?

+1

Answers (1)

Know the Answer?

Maria Burnett · 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.