count the number of times that patient 42473 has been prescribed the ns in their current hospital visit.
select count(*) from prescriptions where prescriptions.hadm_id in ( select admissions.hadm_id from admissions where admissions.subject_id = 42473 and admissions.dischtime is null ) and prescriptions.drug = 'ns'