***Using mysql, my_guitar_shop database

Chapter 8: How to Work with Data Types

1. Write 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 to return 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)