解答

121

SQL文(クエリ)

SELECT
  FORMAT_DATETIME("%A", date_time) AS day_of_week
  , FORMAT_DATETIME("%H", date_time) AS hour
  , COUNT(*) AS pageviews
FROM
  sample.web_log
GROUP BY
  day_of_week
  , hour
HAVING pageviews >= 60
ORDER BY
  3 DESC

結果テーブル

結果テーブル

サポートページに戻る