***Using mysql, my_guitar_shop

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