I am writitng a program that uses a database as the backend and visual basic .net for the gui. I have created a table in the ms sql express that a user can pick from and record to. I can bind the information from the table to a combobox so the users can pick it. The problem is that any new data t...
Just to clarify, what is exactly what you expect as an answer for this question? Percentage of questions with accepted answers depending on the day of the week when the bounty was offered? Average number of answers depending of the day of the week when the bounty was offered? I guess something like that should be possible to do using SEDE. — Martin Sleziak22 secs ago
So of the three options I've given there, Frequency=1 and Frequency=3 actually do not make sense. So probably I could simply remove that part and use Period = DATEPART("weekday", bs.CreationDate).
Number of answers after bounty sounds as an interesting idea. (Although it is probably harder to get.)
Does VoteTypeId=1 mean accepting answer (I read "AcceptedByOriginator" in the FAQ Post. Wouldn't PostId for such vote by answer rather than the question?
I thought that AcceptedAnswerId IS NOT NULL is sufficient to find out whether or not the question has an accepted answer.
Yes, I thought something like that would serve as "tmp" if I wanted to count questions where answer was accepted after bounty. (Of course, changing the direction when comparing the dates.)
I suppose that for counting answers posted after the bounty I'd have to make a joint with Posts a on p.Id=a.ParentId and then compare a.CreationDate and bs.CreationDate.
But it would certainly take me a while to create the query.
