Anton.Sandbox

0

Please login or register to vote for this query.

(click on this box to dismiss)

Portuguese Language

Q&A for linguists, teachers and learners wanting to discuss the finer points of the Portuguese language

/* How many views per question appears in a given week
For instance, is SE more active during the Christmas–NY season
or the community do something else?
*/

DECLARE @All int = ##All:int?1##
DECLARE @UsedId int = ##UserId:int##
DECLARE @YearsBack int = ##YearsBack:int?1##
DECLARE @Month int = ##Month:int?12##
DECLARE @DayStart int = ##DayStart:int?20##
DECLARE @DayEnd int = ##DayEnd:int?31##

;WITH tmp AS
(
  SELECT u.Id
  FROM Users u tablesample(0.001 percent)
  )
  SELECT p.PostTypeId,
  SUM(t.Id) as cnt
FROM Posts p
RIGHT OUTER JOIN tmp t ON t.Id = p.OwnerUserId
GROUP BY t.Id, p.PostTypeId

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results