1. Write a SELECT statement that returns these column names and data from the Order_Items table:

item_id - The item_id column

item_price - The item_price column

discount_amount - The discount_amount column

quantity - The quantity column

price_total - A column thats calculated by multiplying the item price by the quantity

discount_total - A column thats calculated by multiplying the discount amount by the quantity

item_total - A column thats calculated by subtracting the discount amount from the item price and then multiplying by the quantity

Only return rows where the item_total is greater than 500.

Sort the result set by item total in descending sequence.

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

order_id - The order_id column

order_date - The order_date column

ship_date - The ship_date column

Return only the rows where the ship_date column contains a null value.

3. Write a SELECT statement that uses the SYSDATE function to create a row with these columns:

today_unformatted - The SYSDATE function unformatted

today_formatted - The SYSDATE function in this format: MM-DD-YYYY