A SELECT statement that returns the invoicenumber and balance due for every invoice with a non-zero balance and an invoiceduedate that’s less than 30 days from today.
A) SELECT invoicenumber, balance FROM invoices WHERE balance > 0 AND invoiceduedate < current_date - 30
B) SELECT invoicenumber, balance FROM invoices WHERE balance <> 0 AND invoiceduedate < current_date - 30
C) SELECT invoicenumber, balance FROM invoices WHERE balance != 0 AND invoiceduedate < current_date - 30
D) SELECT invoicenumber, balance FROM invoices WHERE balance > 0 AND invoiceduedate < current_date + 30
Correct Option: A) SELECT invoicenumber, balance FROM invoices WHERE balance > 0 AND invoiceduedate < current_date - 30