select distinct on (first_name, last_name) *
from records
where
report_date <= '2017-02-19 15:00:00' and report_date >='2017-02-19 10:00:00'
and score is not null
order by first_name, last_name, report_date desc