title: SQL find changes values and update in a separate table
body: <p>I hope someone could help me out. I am a beginner in SQL and currently learning. </p>
  
  <p>I have a table with a group of employees as in the image shown. Each week an employee from one team changes to a different team. </p>
  
  <p><a href="https://i.stack.imgur.com/YccHM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YccHM.png" alt="enter image description here"></a></p>
  
  <p>Now, how can I retrieve only the changed data from one week to another week in a separate table. Any help would be much appreciated.</p>