Count if not in another table

Hi,   I have an SQL DB with 2 tables, Staff & Pay.   There is a Many  to one rel-ship based on Staff ID column.   A staff is active or inactive based on their start & end date. If end date is b...