that cant be the whole query huh

plus admission_date is date or varchar2, seems varchar2 to me, if that was the case how can you compare varchar2 to date doh