In SQL,

1. Write a SELECT statement that returns these columns from the Invoices table: - The invoice_total column - A column that uses the FORMAT function to return the invoice_total column with 1 digit to the right of the decimal point - A column that uses the CONVERT function to return the invoice_total column as an integer - A column that uses the CAST function to return the invoice_total as an integer.

2. Write a SELECT statment that returns these columns from the Invoices table: - The invoice_date column - A column that uses the CAST function to return the invoice_date column with its full date and time - A column that uses the CAST function to return the invoice_date column with just the year and the month