/* SELECT Posts.Id as postId, Posts.OwnerUserId as userId...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Game Development Meta

Q&A about the site for professional and independent game developers

/*
SELECT Posts.Id as postId, Posts.OwnerUserId as userId, Users.Location, Title, Tags
from Posts
INNER JOIN Users 
ON Users.Id = Posts.OwnerUserId
where Posts.PostTypeId = 1 -- question
and Posts.CreationDate >= '2024-01-01'
*/

SELECT count(distinct Posts.Id) as newQuestions, 
       count(distinct Posts.OwnerUserId) as usersAsking
       --, Users.Location, Title, Tags
from Posts
INNER JOIN Users 
ON Users.Id = Posts.OwnerUserId
where Posts.PostTypeId = 1 -- question
and Posts.CreationDate >= '2024-01-01'

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results