SQL文（クエリ）

SELECT
  COUNT(DISTINCT user_id) users
FROM
  (
    SELECT
      user_id
      , SUM(IF(is_proper IS TRUE, 1, 0)) AS proper_price_flag
    FROM
      sample.sales
    GROUP BY
      user_id
    HAVING proper_price_flag = 0
  )

結果テーブル

サポートページに戻る