A headcount is a count of people at a stated date. It changes when you include contractors, future hires or people who already left. An FTE total measures contracted capacity instead: two half-time employees are two people and one FTE. In this course, start_date is the first employed day and end_date is the first day no longer employed. Keep a person at a snapshot when start_date is on or before that date and end_date is later or missing. The people table belongs to a fictional employer. Its amounts and records are teaching data, not workforce benchmarks.
Headcount answers how many people; the FTE sum answers contracted capacity.
Headcount answers how many people; the FTE sum answers contracted capacity.