Reported in a candidate post, Sep 2020
Find count of employees alive after a given date
Filed under SAP
The question
Write an SQL query to retrieve the number of employees who were alive after January 1st, 2020, using an Employees table containing ID, Name, Date of Birth, and Date of Death columns.
No write-up yet. Related questions below have one.
Related SAP questions
Collected from public candidate posts and coding forums. Updated Nov 2026.