SQL Optimisation 101: How the basics can improve query speed drastically

Dear Diary, A recent event at work took me back to my beginner days at SQL. I was then a bumbling student in STEM who grew starry-eyed as the output of his first SELECT * query materialised. At that point, being able to fetch the details of all emplo...