BusinessVoteDistribution.sql

SELECT
  data.name
  , data.stars AS avgStars
  , data.numberOfReviews
  , (cool / totalVotes) AS `% cool`
  , (useful / totalVotes) AS `% useful`
  , (funny / totalVotes) AS `% funny`
FROM (
       SELECT
         b.business_id
         , b.stars
         , b.name
         , count(r.business_id) AS numberOfReviews
         , sum(r.votes_cool) AS cool
         , sum(r.votes_useful) AS useful
         , sum(r.votes_funny) AS funny
         , sum(r.votes_cool + r.votes_funny + r.votes_useful) AS totalVotes
       FROM business AS b
         INNER JOIN review AS r ON
                                  b.business_id = r.business_id
       GROUP BY b.business_id) AS data
ORDER BY numberOfReviews DESC;