Don't count your chickens before they hatch might not just be wise in life, but can also be a great recommendation for writing performant Spark SQL jobs. Let’s take an example where we need to count number of managers, engineers and sales professionals from an employee dataset.