SQL文（クエリ）

WITH master AS (
  SELECT
    *
    , FORMAT_DATETIME("%u", date_time) AS day_number
    , FORMAT_DATETIME("%A", date_time) AS day_of_week
  FROM
    sample.web_log
)
SELECT
  day_of_week
  , COUNT(*) AS sum_pv
FROM
  master
GROUP BY
  day_of_week
ORDER BY
  MOD(MAX(cast(day_number AS int64)), 7)

結果テーブル

サポートページに戻る