0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to improve their interpersonal communication skills

SELECT 
  cdate
,     
  vc/nq
  as [Number of views per question created at date]

FROM (SELECT
    CAST(CreationDate AS DATE) AS cdate,
    0.0+COUNT(*) AS nq,
    0.0+SUM(ViewCount) AS vc
    FROM Posts
  WHERE PostTypeId = 1 AND CreationDate > '2018-11-01' AND ClosedDate IS NULL
  GROUP BY CAST(CreationDate AS DATE)
  ) foo
ORDER BY cdate

fork query

edited jan 3 19

created jan 3 19 anonymous