count the number of times patient 1114 had been prescribed 1/2 ns on their current hospital visit.
select count(*) from prescriptions where prescriptions.hadm_id in ( select admissions.hadm_id from admissions where admissions.subject_id = 1114 and admissions.dischtime is null ) and prescriptions.drug = '1/2 ns'