In following data set, I have 3 different products. Each one have been rated in every month of year and the monthly average rating for each product is written in second column. How can I get best ratings_average for each month a long with the product_id? Or in another word how can I get most popular product of each month?
Please download following image and it contains my data set:
https://easyupload.io/9mkjlk
I'm not sure that many people will click on that link...
Can you attach the picture to this post? Or, better, generate a script that can be used by us to help you? (Create table, add a few rows of data, and any indexes)