If you want just these patients with 2 visits change
having count(VISITS.visit_date)> 1 to
having count(VISITS.visit_date)= 2
else you'll get all that have 3,4 or more visits.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.