Given the following auction data, how would you find the percent difference between a persons most recent and previous bid for a product using Oracle SQL?

The duplicate sequence (SEQ) for person A and B is representative of data I am working with.

An example of your SQL would be very appreciated.

```
TXN_TIME              | SEQ | PERSON | PRODUCT | TRANSACTION | BID  |
2017-11-22 15:41:10:0 | 20  | A      | 1       | BID         | 12   |
2017-11-22 15:35:10:0 | 10C | A      | 1       | CXLBID      | NULL |
2017-11-22 15:34:25:0 | 10  | A      | 1       | BID         | 10   |
2017-11-22 15:35:40:0 | 6   | A      | 2       | BID         | 4    |
2017-11-22 15:34:50:0 | 1C  | A      | 2       | CXLBID      | NULL |
2017-11-22 15:34:20:0 | 1   | A      | 2       | BID         | 5    |
2017-11-22 15:35:45:0 | 6   | B      | 2       | BID         | 2    |
2017-11-22 15:34:55:0 | 1C  | B      | 2       | CXLBID      | NULL |
2017-11-22 15:34:25:0 | 1   | B      | 2       | BID         | 1    |

```