Scottish Friend's Counting Problem

The joke plays on the stereotype that Scottish people are heavy drinkers who fall asleep easily. The humor comes from the unexpected turn where, instead of giving an answer, the friend falls asleep while counting. The number of sexual partners becomes irrelevant as the focus shifts to the friend's sleepiness.