SQL文（クエリ）

WITH all_user AS (
  SELECT
    user_id
  FROM
    sample.sales
  GROUP BY
    user_id
)
, user19 AS (
  SELECT
    user_id
    ,
  FROM
    sample.sales
  WHERE
    EXTRACT(YEAR FROM date_time) = 2019
  GROUP BY
    user_id
)
SELECT
  user_id
FROM
  all_user EXCEPT DISTINCT
  SELECT
    user_id
  FROM
    user19
  ORDER BY
    user_id
  LIMIT 10

結果テーブル

サポートページに戻る