I figured it out. Keep giving Coffee to Sophia at the college at night. After you give her coffee a few times you'll unlock the Hospital. Keep following that quest to unlock the sleeping pills.
