about how automation will affect the job prospects
This is always an interesting topic to dig up data on. We are always hearing about automation being an impending (we're almost there!) danger that is accelerating. The data doesn't bear this out, however.
Step 1. determine how to measure automation's effect. The best indicator is an economic term called "productivity". We know productivity and automation are correlated because the biggest shifts in productivity come from technological advance (and not say, superhuman capabilities being developed by worker)
Step 2. Look at historical data. It turns out productivity has been climbing but not as fast as it was from 1990-2010 (very steep climb). In fact the last decade 2010-2020 has seen some of the slowest increases in productivity since the middle of the 20th century.
Source: inferred from this productivity vs compensation graph from world economic forum.
https://assets.weforum.org/editor/HFNnYrqruqvI_-Skg2C7ZYjdcXp-6EsuSBkSyHpSbm0.png