query.sql

-- Number of restaurants with 5, 4, 3, 3, 1 and 0 average ratings
SELECT stars_avg, count(stars_avg) 
FROM (
	SELECT FLOOR(AVG(r.stars)) AS stars_avg
	FROM rates AS r
	JOIN venues AS v ON v.id = r.rateable_id
	JOIN types AS t ON t.id = v.type_id
	WHERE t.name = "Restaurants"
	AND r.rateable_type = "Venue"
	GROUP BY v.id) AS star_avgs_tbl
GROUP BY stars_avg
ORDER BY stars_avg DESC