No worries. The data explorer is really good for trying out queries before you add them as custom SQL badges (though the data explorer ones don’t need the backfill
part).
Though I think the second query above has all the info in you need. The solutions are kept in the post_cutom_field
table as is_accepted_answer
in the name
column. And that second query grants the TechSupport badge for 10 solutions (HAVING COUNT(*) > 9
), so for the ones you want from the OP you just need to copy that query and change the bottom number to 19, 29, 39, and so on.