TABLE1:
| Id | Name | Status | Risk | Date |
| 100 | ABC | Open | Low | 10/1/2014 |
| 100 | ABC | Closed | Medium | 3/2/2014 |
| 200 | DEF | Open | Low | 1/1/2015 |
| 200 | DEF | Open | Medium | 1/2/2015 |
| 200 | DEF | Closed | High | 1/3/2015 |
| 300 | XXX | Open | High | 5/6/2015 |
| 300 | XXX | Open | Low | 7/7/2015 |
| 300 | XXX | Closed | High | 8/9/2015 |
| 400 | YYY | Open | Low | 1/2/2015 |
| 400 | YYY | Closed | Medium | 2/2/2015 |
I would like to see where the Risk for a Id changes from when we first receive the Id's risk in the above table to when their Status changes to Closed
How many Ids changes risks/ For a closed id in the above table - has the status changes since Open? A flag needs to be added to know rish changes or not(y/n)
Help me on the above?
