NewUserProgress

1

Please login or register to vote for this query.

(click on this box to dismiss)

Worldbuilding

Q&A for writers/artists using science, geography and culture to construct imaginary worlds and settings

with QuestionScore as (
  select id, score, ownerUserId
  from posts
  where postTypeId = 1),
     AnswerScore as (
  select id, score, ownerUserId
  from posts
  where postTypeId = 2)
select * from (
  select u.id as [User Link], u.reputation, u.creationdate,
  (select count(*) from questionScore where owneruserid = u.id) questions,
  (select sum(score) from questionScore where owneruserid = u.id)*5 questionScore,
  (select count(*) from answerScore where owneruserid = u.id) answers,
  (select sum(score) from answerScore where owneruserid = u.id)*10 answerScore
  from users u
  where datediff(d, creationdate, getdate()) < ##daysSinceJoined##) u
where u.questionScore > 0 or u.answerScore > 0
order by reputation desc

Enter Parameters

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