Untitled query #32060

SQL

WITH counted AS (
         SELECT project,
                page_title,
                SUM(view_count) as views
           FROM pageview_hourly
          WHERE year=2018
            AND agent_type = 'user'
            AND page_title != '-'
            AND month=12
            AND day=12
            AND hour=12
          GROUP BY project, page_title, year, month, day, hour
        ),

        ranked AS (
         SELECT project,
                page_title,
                views,
                rank() OVER (PARTITION BY project ORDER BY views DESC) as ranking
           FROM counted
        )

 SELECT project,
        CONCAT('https://', project, '.org/wiki/', page_title) AS article,
        views
   FROM ranked
  WHERE ranking <= 100
;
SQL

Checking query status...
