My SQL: Chapter 8

Chapter 8 How to work with data types Exercises 1Write a SELECT statement that returns these columns from the Products table: The list _price column A column that uses the FORMAT function to return the list price column with 1 digit to the right of the decimal point A column that uses the CONVERT function toreturn the list price column as an integer A column that uses the CAST function to return the list _price column as an integer 2. Write a SELECT statement that returns these columns from the Products table The date added column A column that uses the CAST function to return the date_added column with its date only (year, month, and day) A column that uses the CAST function to return the date_added column with just the year and the month A column that uses the CAST function to return the date_added column with its full time only (hour, minutes, and seconds)