SQL for badge that is awarded weekly for top "accepted answerer"

Wondering about an SQL query to award a badge weekly to the user with the most accepted answers over the past week, any suggestions?

6 Likes