The temp table - I only selected it, since I do NOT have a DB that I can use for testing answers to SSC questions.

The major part of the solution, which can be used on the real table (be careful and be sure to test, test and then test again) before using in production. I would suggest to copy some of the data from the real table into a test table, and then once you are sure that the code does what you need done, and nothing more, then use in production.