Using Nested Subqueries The Marketing Department is interested in developing a campaign pointed toward the Orion Club members low activity group. They specifically want to identify the customer IDs of this group whose last order was placed before 1Jan2012. The requested report should contain the customer ID and the date of the customers last order. The following tables contain the data that you need:

orion.customer_type contains the columns Customer_Type and Customer_Type_ID.

orion.customer contains Customer_Type_ID and Customer_ID.

orion.order_fact contains Customer_ID and Order_Date..