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.
The start boundary is inclusive and the end boundary is exclusive.
The start boundary is inclusive and the end boundary is exclusive.