Which of the following statements best describes what this SELECT statement does? SELECT invoice_number, invoice_date, C
Posted: Fri Jul 01, 2022 5:47 am
Which of the following statements best describes what thisSELECT statement does? SELECT invoice_number, invoice_date, CASEWHEN (SYSDATE() - invoice_date) >= 30 AND (SYSDATE() -invoice_date) < 60 THEN invoice_total ELSE 0 END AS "30-60",CASE WHEN (SYSDATE() - invoice_date) >= 60 AND (SYSDATE() -invoice_date) < 90 THEN invoice_total ELSE 0 END AS "60-90",CASE WHEN (SYSDATE() - invoice_date) > 90 THEN invoice_totalELSE 0 END AS "Over 90" FROM invoices