danimohamadnejad
2 months ago
204
2
General

How can I get highest rated product of each month?

Posted 2 months ago by danimohamadnejad

Hello every body In following table, I have 3 different products and average rating for each product in each month of year. What query can give me highest rated product in each month with its average rating?

`` productid average_rating ratings_month 1 1 1 1 3 2 1 5 3 2 2 1 2 4 2 2 1 3 3 2 1 3 3 2 3 4 3

``

Please sign in or create an account to participate in this conversation.