SQL文（クエリ）

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

結果テーブル

サポートページに戻る