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