Search Results

You don't need to perform any join at all. SELECT ParentId AS [Post Link] , OwnerUserId AS [User Link] , COUNT(Id) AS Answers FROM Posts WHERE ParentId IS NOT NULL …

You inject the button using jQuery.prepend(), which inserts the button as the first child of the .prettyprint code block. Therefore, when the bookmarklet is invoked, and it selects the contents of th …

Since StackExchange can refresh page contents dynamically, the following sequence of events is possible: Page contains some code block(s). …

There is a simple way to calculate rolling averages in SQL, with a caveat. SELECT CreationDate , Score , avg(CAST(Score AS FLOAT)) OVER ( ORDER BY CreationDate ROWS BETWEE …

Implementation The query is quite well written for what it does. I just have a few minor nitpicks about its implementation. The FROM, GROUP BY, and ORDER BY clauses are all subsidiary to the SELECT …

group by and order by are both subordinate clauses to select, and should therefore be indented at the same level as from and where.

Answering your questions in reverse order… Your HAVING clause is clearer than than an anti-join condition in the WHERE clause. It is also more efficient — tick the "Include execution plan" checkbox …

Race condition If an established user asks a question at the exact same instant that a new user makes a first post, it's possible that the established user's question would be treated as a first post …

It's not obvious what this query does without reading the code. You should add a title and description in Stack Exchange Data Explorer. I also find the columns illogically arranged: I would expect …

Due to the way you used the ##QuestionTag1## parameter, you have to enter 'java' in the input field (with the single quotes) rather than java. I'm pretty sure that that is an indicator of an SQL inje …

Technically, the full outer join is insufficient. If during a certain week there was not a single user who posted their first question or answer, the plot for that week needs to be 0. It would be mi …

I think that the rounding behaviour is a bug. The output looks just fine if you tick the "Text-only results" checkbox. Simplified tag canonicalization: WITH CanonicalTags AS ( SELECT Master.Id …

I would encourage you to produce more explicit output, particularly with the filenames. If I wanted to reverse the process and scrape the code into files on my machine, using a Python script such as …

since you used your program to produce this question itself, I suspect that your tool is responsible for introducing the bug in the immediately following line: ps.print(" "); // format as code for StackExchange …

GROUP BY Users.Id is sufficient. There is no reason why you also need to GROUP BY DisplayName.