0

Please login or register to vote for this query.

(click on this box to dismiss)

Count total progress to Socratic badge

Perguntas e respostas para programadores profissionais e entusiastas

SELECT
    count(*) AS Counter
FROM (
  SELECT DISTINCT (cast ([CreationDate] as date)) AS X
  FROM
      Posts
  WHERE
      OwnerUserId = ##UserId## and
      PostTypeId = 1 and
      Score > 0 and
      DeletionDate is null and
      ClosedDate is null
) O

fork query

edited dec 28 17

created dec 28 17 Guilherme Nascimento