Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment
select votetypeid,count(*) from posts p inner join votes v on v.postid = p.id group by votetypeid