SQL文（クエリ）

SELECT
  prefecture
  , SUM(quantity) AS sum_qty
FROM
  sample.sales
  LEFT JOIN sample.customers
  USING
    (user_id)
GROUP BY
  prefecture
ORDER BY
  sum_qty
LIMIT 3

結果テーブル

サポートページに戻る