I am speaking from a first person perspective because I came to the question by knowing what I, a man dreams about, most frequently. I thought that it may be just me and not men that dream about sex so often, but i betted on it being men because it seems men are hornier on average.
But i am not horny when awake. I do get horny, but even when i do, it is just like, "Well... i could masturbate, or i could go have a roast beef sandwich." Only when I'm plastered to the point of not remember am i like, "Ur a woman... um... I wanna have sex with uuu." - Reports from friends. Actually what they told me I said was, "I wanna fuck alternate dimensions through you." And things I said apparently made one of them tell me, "No, i'm sorry Colin, your cock does not beat a strait flush."
But otherwise, when i'm awake, i'm not nearly as interested in sex as my lucid dreaming counterpart. He is a sex maniac. When i wake up remembering he fucked a whole cheerleader squad, i'm like, "Huh?" And go make myself a roast beef sandwich.