Someone who knows everything about a subject, can teach it, but is unable to perform it at a competitive level.
"You idiot, she's totally into you. Why don't you ask her out"
"Good call Coach. Hey, why haven't you asked _____ out yet then?"
"Insert long winded explanation"