I need help with my SQL homework.

1.

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

The list_price column

A column that uses the TO_CHAR function to return the list_price column with currency formatting.

2.

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

The card_number column

The length of the card_number column

The last four digits of the card_number column

When you get that working right, add the columns that follow to the result set. This is more difficult because these columns require the use of functions within functions.

A column that displays the last four digits of the card_number column in this format: XXXX-XXXX-XXXX-1234. In other words, use Xs for the first 12 digits of the card number and actual numbers for the last four digits of the number.

3.

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

The order_id column

The order_date column

A column named approx_ship_date thats calculated by adding 2 days to the order_date column

The ship_date column

A column named days_to_ship that shows the number of days between the order date and the ship date

When you have this working, add a WHERE clause that retrieves just the orders for March 2012.