MYSQL

Chapter 8 How to work with data types Exercises 1. Write a SELECT s from the I 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 column as an integer Write a SELECT statement that returns these colums from the Inmvoices table: 2. 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