**** Using Mysql, my_guitar_shop.sql

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)

Chapter 9: How to Use Functions

1. Write a SELECT statement that returns these columns from the Products table:

The list_price column

The discount_percent column

A column named discount_amount that uses the previous two columns to calculate the discount amount and uses the ROUND function to round the result so it has 2 decimal digits

2. Write a SELECT statement that returns these columns from the Orders table:

The order_date column

A column that uses the DATE_FORMAT function to return the four-digit year thats stored in the order_date column

A column that uses the DATE_FORMAT function to return the order_date column in this format: Mon-DD-YYYY. In other words, use abbreviated months and separate each date component with dashes.

A column that uses the DATE_FORMAT function to return the order_date column with only the hours and minutes on a 12-hour clock with an am/pm indicator