I have a friend with a dog like this, I think it's Australian Shepherd. That dog is smarter than most people I've met. It would hang out with my mom's dogs, a wheaten terrier and a labradoodle, and it would watch the labradoodle eat the wheaten's fresh diarrhea, and it had this look on it's face... Just a severe look of disapproval.
We had a schnauzer mix that could do all these things ("bang," twirl, etc), except instead of teaching her to fetch beer, we taught her to weed the garden, take messages to whomever you asked her to, and shut the door when she came in from outside.
(She was also a terrible snitch, and would come get you whenever she thought the other dog was doing something bad.)
this guy actually takes the time to train his dog, unlike 90% of the dog owners i see whose dogs have little to no training, or their owner just tugs uninterestedly on the leash for the duration of the walk.
My friends and I taught a young black lab to do this in about an hour, as a side project, while we were getting high and drunk. The dog was willing to work for ice cubes.