Q&A for scientists using computers to solve scientific problems
select votetypeid,count(*) from posts p inner join votes v on v.postid = p.id group by votetypeid