Question

SQL - Write A SELECT statement that determines whether the PaymentDate column of the Invoices table has any invalid values. To be valid, PaymentDate must be a null value if there's a balance due and a non-null value if there's no balance due. Code a compound condition in the WHERE clause that tests for these conditions

TIA

Answer 1

If you have any doubts, please give me comment...

SELECT InvoiceID, BalanceDue, PaymentDate

FROM Invoice

WHERE (BalanceDue=0 AND PaymentDate IS NULL) OR (BalanceDue<>0 AND PaymentDate IS NOT NULL);