3b

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

Q&A about the site for music historians, critics, and fans

SELECT COUNT(*) AS N_x
	, ViewCountX2 AS x
FROM (
	SELECT SUM(ViewCountX) AS ViewCountX2
		, COUNT(*) AS num_posts
		, OwnerUserIdX AS OwnerUserIdX2
	FROM  ( 
	  SELECT 
	  YEAR(CreationDate) AS CreationDate_Year
	  , MONTH(CreationDate) AS CreationDate_Month
	  , DAY(CreationDate) AS CreationDate_DAY
	  , ViewCount AS ViewCountX
	  , OwnerUserId AS OwnerUserIdX
		FROM Posts
	) AS X
	WHERE ( CreationDate_Year = 2017)
	GROUP BY OwnerUserIdX
) AS X2
GROUP BY ViewCountX2
ORDER BY x DESC
;

Enter Parameters

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