Count history records

I have jobnumber, startdateofjob,enddateofjob in SQL table. If there is ‘1900-01-01 00:00:00.000’ in enddateofjob column, this means it is active job. Other inactive job. I