-- order id that changed from not canceled to is canceled because order state is sent to warehouse and created at is more than 7 days
-- order id: 3486372
-- user id: 1122144

-- order id that has not changed because the order state is captured
-- order id: 3047846
-- user id: 1716530

-- order - - Shows that is_canceled is now true
SELECT * FROM core.orders where id = 3486372
SELECT * FROM core.orders where user_id = 1710281 order by created_at

-- order_type - - Column order_type and order_type_detail changed from Existing Customer Manual to Cancel
-- NOTE: even though it is a canceled order, starts free trial is TRUE -- should this be the case
SELECT * FROM dtc.order_types WHERE order_id = 3486372

-- fact_order - - Check that naming changed from canceled --> is_canceled and from False --> True
SELECT * FROM dw.fact_order where order_id = 3486372

-- order attributes - - Check that the new column, is_canceled, is apart of the order_attributes table and is accurate
-- is_canceled = True (changed)
SELECT * FROM analytics.order_attributes where order_id = 3486372
-- is_canceled = False (unchanged)
SELECT * FROM analytics.order_attributes where order_id = 3047846

-- user_order_stats - - Check that the num_orders has changes from (production) -> (development)
-- num_orders went from 4 (production) --> 3 (development)
SELECT * FROM dtc.user_order_stats where user_id = 1710281
-- num_orders went from 1 (production) --> 1 (development)
SELECT * FROM dtc.user_order_stats where user_id = 3047846