Write a select statement that returns the order_id and customer_id from the orders table. Then, add a conditional field that returns the following: If the order has not yet shipped, return the text This order has not yet shipped. If the order has shipped, return the text This order was shipped on: and then return the shipped_date formatted as MM/DD/YYYY. (The way US users are accustomed to reading dates.) Finally, filter your output for orders with an order_id greater than 700 and order by order_id