SQL query for multiple rows in single column [closed]

This isn’t really a good quetion and is a very likely candidate for someone down voting it.
Look here for an example schema

http://www.databaseanswers.org/data_models/patient_care/index.htm