Stupid question incoming. Please be kind as I am just learning SQL(MySQL to be exactly) and English is not my native language.
So, there are two types of users - who post ***questions*** and who posts ***answers*** to these questions.
And I need to get top 10 rated users who posts answers.
Users who posts answers, getting rated, calculated like this: (average rating of all questions for last 7 days, rated by who asked) * (total number of answers for last 7 days) / (average response time in minutes between last question and answer to this question, again, for last 7 days).
Thanks in advance, I'm just stuck at this point and can't understand how to solve this.