brandon-beacher

Here's my sample data set

mysql> SELECT tf.id, tf.authorization_id_response, tf.tran_type FROM transaction_feeds tf;
+-----+---------------------------+-----------+
| id  | authorization_id_response | tran_type |
+-----+---------------------------+-----------+
| 239 | 223672                    | 9120      | 
| 240 | 223672                    | 9220      | 
| 241 | 223673                    | 9120      | 
+-----+---------------------------+-----------+