/* SCD - Slowly Changing Dimension - Type 3 - State dimension */ /* Did any state change its region? */ select * from state; select * from state where region != region_prev;