解答

170

SQL文(クエリ)

WITH master AS (
  SELECT
    cid
    , session_count
    , MAX(cv_page) AS cv
  FROM
    (
      SELECT
        *
        , IF(page = "/thank_you/", 1, 0) AS cv_page
      FROM
        sample.web_log
    )
  GROUP BY
    cid
    , session_count
)
SELECT
  COUNT(*) AS cv
FROM
  master
WHERE
  cv > 0

結果テーブル

結果テーブル

サポートページに戻る