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