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

**URL:** https://meta.discourse.org/t/sql-for-badge-that-is-awarded-weekly-for-top-accepted-answerer/58393
**Category:** Feature
**Tags:** solved, reporting
**Created:** [29.Май.2016 11:51:44 UTC](https://meta.discourse.org/t/sql-for-badge-that-is-awarded-weekly-for-top-accepted-answerer/58393 "2016-05-29T11:51:44Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![auryn\_macmillan](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/auryn_macmillan/32/56633_2.png) [@auryn\_macmillan](https://meta.discourse.org/u/auryn_macmillan)
#### Post date: [29.Май.2016 11:51:44 UTC](https://meta.discourse.org/t/sql-for-badge-that-is-awarded-weekly-for-top-accepted-answerer/58393/1 "2016-05-29T11:51:44Z")

</div>

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