MYSQL Work with nulls and test expressions 10. Write a SELECT statement that ret

Question

MYSQL

Work with nulls and test expressions 10. Write a SELECT statement that returns these columns from the Invoices table: invoice _number invoice date balance_due The invoice_number column The invoice_date column The invoice _total column minus the payment_total and credit total columns payment date The payment date column Return only the rows where the payment_date column contains a null value. This should retrieve 11 rows. 11. Write a SELECT statement without a FROM clause that uses the CURRENT DATE function to return the current date in its default format. Use the DATE_FORMAT function to format the current date in this format: This displays the month, day, and four-digit year of the current date. Give this column an alias of current_date. To do that, you must enclose the alias in quotes since that name is already used by the CURRENT_DATE function. 12. Write a SELECT statement without a FROM clause that creates a row with these columns: starting_principal interest Starting principal of $50,000 65% of the principal principal_plus_interest The principal plus the interest To calculate the third column, add the expressions you used for the first t columns wo

Explanation / Answer

10: Sql query

SELECT invoice_number, invoice_date,balance_due, payment_date from Invoices WHERE payment_date IS NULL;

11: Sql Query

SELECT DATE_FORMAT(CURRENT_DATE, '%M-%D-%Y');

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.