google big table query to get most popular domains submitted to hacker news

gistfile1.txt

https://bigquery.cloud.google.com/queries/hacker-news-analytics?pli=1

query.sql

SELECT
  user_domain,
  COUNT(*) AS activity_count
FROM (
  SELECT
    DOMAIN(url) AS user_domain,
    year
  FROM (
    SELECT
      url,
      INTEGER(time / (60*60*24*365)) + 1970 AS year
    FROM
      [fh-bigquery:hackernews.stories] )
  WHERE
    year = 2015)
    GROUP BY
  user_domain
HAVING
  user_domain IS NOT NULL
  AND user_domain != ''
ORDER BY
  activity_count DESC
LIMIT
  1000