The Stack Exchange Data Explorer is a tool used to look at the data from Stack Exchange websites using SQL queries.
Questions tagged [data.stackexchange.com]
19 questions
0
votes
1 answer
Teleform VBA recieving error remove preceding zeros then fill blank fields with one zero 20170412
This is my VBA in a form for a program called Teleform. My tech support is only for the program and they are unable to assist with scripting to remove preceding zeros from collected data of 2 specific fields. The fields are numeric Month and day…

thangamajog
- 1
- 1
0
votes
4 answers
Return results from multiple tables
I am doing analysis on the Stack Overflow dump.
Problem statement: I have 4 tables and require result in the format given.
Table 1: UserID Year QuestionsOnTopicA
Table 2: UserID Year AnswersOnTopicA
Table 3: UserID Year QuestionsOnTopicB
Table 4:…

Mohit Jain
- 135
- 1
- 4
- 12
-1
votes
1 answer
List top 10 gold badge medalists in Code Review
What I want to achieve in particular is getting top 10 gold badge medalists in Code Review.
(A Data Explorer solution is acceptable, too.)
Is there a way to do it?

coderodde
- 1,269
- 4
- 17
- 34
-2
votes
2 answers
SEDE query returns no rows
I have the following query on https://data.stackexchange.com/stackoverflow
SELECT TOP 10 * FROM Posts
WHERE PostTypeId = 2
AND CreationDate > '2022-05-06'
AND CommentCount = 3
AND Tags LIKE '%php%'
ORDER BY CreationDate DESC
I am trying to…

Vivek Sharma
- 101
- 3
- 11