SELECT dt, SUM(CASE WHEN (view_count < 2) THEN 1 ELSE 0 END) AS 1dist, SUM(CASE WHEN ((view_count >= 2) AND ((view_count < 5))) THEN 1 ELSE 0 END) AS 2_4dist, SUM(CASE WHEN ((view_count >= 5) AND ((view_count < 10))) THEN 1 ELSE 0 END) AS 5_9dist, SUM(CASE WHEN ((view_count >= 10) AND ((view_count < 25))) THEN 1 ELSE 0 END) AS 10_24dist, SUM(CASE WHEN ((view_count >= 25) AND ((view_count < 50))) THEN 1 ELSE 0 END) AS 25_49dist, SUM(CASE WHEN ((view_count >= 50) AND ((view_count < 100))) THEN 1 ELSE 0 END) AS 50_99dist, SUM(CASE WHEN (view_count >= 100) THEN 1 ELSE 0 END) AS 100_plusdist, SUM(CASE WHEN (view_count < 2) THEN view_count ELSE 0 END) AS 1agg, SUM(CASE WHEN ((view_count >= 2) AND ((view_count < 5))) THEN view_count ELSE 0 END) AS 2_4agg, SUM(CASE WHEN ((view_count >= 5) AND ((view_count < 10))) THEN view_count ELSE 0 END) AS 5_9agg, SUM(CASE WHEN ((view_count >= 10) AND ((view_count < 25))) THEN view_count ELSE 0 END) AS 10_24agg, SUM(CASE WHEN ((view_count >= 25) AND ((view_count < 50))) THEN view_count ELSE 0 END) AS 25_49agg, SUM(CASE WHEN ((view_count >= 50) AND ((view_count < 100))) THEN view_count ELSE 0 END) AS 50_99agg, SUM(CASE WHEN (view_count >= 100) THEN view_count ELSE 0 END) AS 100_plusagg FROM ( SELECT CONCAT( CONCAT( LPAD(year, 4, "0"), "-", LPAD(month, 2, "0"), "-", LPAD(day, 2, "0"), "T", LPAD(hour, 2, "0"), ":00:00") ) AS dt, project, language_variant, page_title, SUM(view_count) AS view_count FROM wmf.pageview_hourly WHERE year=2015 AND month=7 AND day=7 AND agent_type = 'user' AND page_title <> '-' GROUP BY year, month, day, hour, project, language_variant, page_title ) pages GROUP BY dt ORDER BY dt LIMIT 1000000000 ;