This is a challenging problem, try your best. There are many ways to accomplish it$,$ but the

simplest using on SQL you already know is to use the UNION statement to join two queries

together. Approach this by creating the two queries first and then combining them with the

UNION clause.

You have been asked to create a query that will display the word SHIPPED for any order that

has shipped and the words NOT SHIPPED for any order that has not shipped yet. You can tell

if an order has shipped by looking at the ORDER$\_$STATUS field in the OE$.$ORDERS table. An

ORDER$\_$STATUS value $>=($greater than or equal$)$ to $4$ has been SHIPPED, and anything $<$

$($less than$)4$ has is NOT SHIPPED.

You will use a UNION to join two queries together.

Query #$1$:

Using the OE$.$ORDERS table, select ORDER$\_$ID$,$ ORDER$\_$DATE, and a character field

$$SHIPPED$$ with an alias of STATUS. Only select orders with an ORDER$\_$STATUS

value that is greater or equal to $4$