DataLemur: Average Review Ratings

1
2
3
4

SELECT EXTRACT(MONTH FROM submit_date) AS mth, product_id, ROUND(AVG(stars), 2) AS avg_stars
FROM reviews
GROUP BY product_id, mth
ORDER BY mth, product_id ASC