I want to get last 7day average vote values

Question

Hi,

 

 I want to get the last 7day average vote values passing CardID and TeamID  using stored procedure:

 

this is my table structure :

 

 

 

 

using Vote table to get last 7days average vote value based on last modified datetime.

thank you