SELECT count(ncdpersonscreenall.pid) AS total,pid
FROM ncdpersonscreenall
WHERE screen_date BETWEEN '2014-10-01' AND '2015-09-30'
GROUP BY ncdpersonscreenall.pid
HAVING count(ncdpersonscreenall.pid) > 1;