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 characters needed characters left characters exceeded

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

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

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.