I'm working on this table as shown below it has name, date,id and key. I would like to insert into new table where the old\_name column maintains the change in name for that key. The output result is shown below as well. Thanks

```
           id       name        date                    Key
            1       charles     2004-05-07              1001
            2       CON         2004-05-07              1001
            3       Virginia    2006-09-08              1001
            4       MART        2012-01-03              1001
            5       McDonalds   2013-12-30              1001

    OUTPUT 

            id   old_name          name        date                 Key
            1     NULL             charles     2004-05-07           1001
            2     charles          CON         2004-05-07           1001
            3     CON              Virginia    2006-09-08           1001
            4     Virginia         MART        2012-01-03           1001
            5     MART             McDonalds   2013-12-30           1001

```