0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people studying math at any level and professionals in related fields

SELECT
  CAST(p.CreationDate AS Date),
---  MAX(p.ViewCount) AS [Maximum],
---  SUM(p.ViewCount) AS [Sum],
  ROUND((MAX(p.ViewCount))*100.0/(SUM(p.ViewCount)),2) AS [Percentage]
FROM Posts p 
WHERE (p.PostTypeId=1) 
   AND (p.CreationDate >= '##Date1?2020-01-01##') AND (p.CreationDate <= '##Date2?2021-01-01##')
GROUP BY CAST(p.CreationDate AS Date)
ORDER BY CAST(p.CreationDate AS Date)

fork query

edited nov 6

created nov 6 Martin20528