Life is hard, nothing is perfect. I was given these 2 raw datasets and my task was to generate a full history log as shown. I had to get it done in MySQL 5.6.10 but you don't have to.
- One customer can recieve multiple tags at the same time
- We are only interested in INVENTORY tag type