SQL文（クエリ）

SELECT
  prefecture
  , COUNT(DISTINCT user_id) AS premium_or_male_users
FROM
  sample.customers
WHERE
  is_premium IS TRUE
OR  gender = 1
GROUP BY
  prefecture
ORDER BY
  2 DESC
LIMIT 3

結果テーブル

サポートページに戻る