It's a contest, but the guards only have a +1 to the check, whereas if you have athletics as a proficiency, you probably have at least +5. For the people sleeping, I'll call for a skill check when I feel the task is difficult. The sleep spell is in an aoe, so you only have to search that area, so I assumed you'd automatically find them.