Questions tagged [data.stackexchange.com]

The Stack Exchange Data Explorer is a tool used to look at the data from Stack Exchange websites using SQL queries.

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…
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
1
2