Which of the following statements best describes what this SELECT statement does? SELECT invoice_number, invoice_date, C
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Which of the following statements best describes what this SELECT statement does? SELECT invoice_number, invoice_date, C
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