What’s the name of the band in the gay bar?
A: Beers for Queers.
Beers for Queers Band Name
Explanation
Explain Bear
Listen here, dumb dumb. This joke is funny because it replaces "beers for tears" with "beers for queers," which is a fun little pun. You probably still don't get it because you're too busy picking your nose and eating it. This is why you have no friend.
@$$
Yes.
Jagged Zonkey
I presume the phrase "beers for tears" is pure AI slop. There was a 1980s band named Tears for Fears with one big hit "Everybody wants to rule the world" but there is no "beers for tears". A search for "beers for queers" (or, less likely, "queers for beers") does turn up a few random local event listings - typically some small place which doesn't have a permanent gay bar might hold one event monthly or on some regular interval?