Who posted in: Right join with group by clause

Member name Posts
vibinvictoria 4
andrewsw 4
baavgai 1