question

danielwoods21 avatar image
danielwoods21 asked

How can I get highest average_ratings of each ratings_month with the product_id?

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

querymysqlsqlserver
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·

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)

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.