I have a lot of questions here and a great majority have answers, and for a great majority of those an answer has been accepted.

Is it possible for someone to figure out what fraction of my questions have accepted answers without going through the 44 pages of questions and counting?

Is it then possible to explain the procedure to me as if I were a child? I'm not familliar with database queries, anything besides python is a real challenge for me.


You can use the advanced search features of the normal site - no need for fancy database queries. It's not so easy to find, but there is a little "Advanced Search Tips" whenever you search and some of these features are relevant for you.

Screenshot of the search bar with the "Advanced Search Tips" highlighted by a red circle

First you go to your profile on the main site. That's here. As you can see the searchbar is already filled with your user-id. No need to search for that somewhere. The searchbar reads user:12102, which will give you all posts from you.

Next we want to limit this down to questions. There is a handy way to do this: just add "is:question" or in short "is:q" to the searchbar. Like here (1296 posts from you are questions - impressive!).

Next we want to limit this down to all those with an accepted answer: "hasaccepted:yes" => user:12102 hasaccepted:yes (912 of your questions have an accepted answer).

Together those two search queries mean that you have accepted an answer in 912 / 1296 ~ 70% of all cases where you asked a question.

Minor addition: those are only undeleted questions, I don't know if you have deleted ones.

If you want to find those without an accepted answer you can just change the query to "hasaccepted:no" like here, for example in case you want to search for interesting questions that you want to offer a bounty on.

  • $\begingroup$ "impressive!"? by coincidence I just right now wrote this It's a scourge, my life is an endless series of cups of coffee and pavlovian clicks of the Post Your Question button. $\endgroup$
    – uhoh
    Mar 25 '19 at 12:12
  • $\begingroup$ This works very well, and is really easy to use, thank you very much! $\endgroup$
    – uhoh
    Mar 25 '19 at 12:19
  • 1
    $\begingroup$ @uhoh Then you are a dream of many smaller sites on the network. Enjoy your cup of cofee and have fun with the advanced search features and your new found question / answer statistics ;) $\endgroup$
    – Secespitus
    Mar 25 '19 at 12:24
  • 1
    $\begingroup$ Just noting for future reference; 70% of my questions have an accepted answer, 85% have one or more answers, 13% of all site questions are mine, and 20% of all unanswered questions are mine, so it looks like I have my work cut out for me. Thanks again! $\endgroup$
    – uhoh
    Mar 27 '19 at 4:06
  • $\begingroup$ I'm up to 72% of my questions having an accepted answer, but wow, as a whole the site is only at about 54% or 5475/10064! $\endgroup$
    – uhoh
    Apr 1 '19 at 17:10

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .