解答

117

SQL文(クエリ)

SELECT
  REGEXP_EXTRACT(name, r"^[^\s]+") AS last_name
  , COUNT(*) AS users
FROM
  sample.customers
WHERE
  gender = 2
GROUP BY
  last_name
HAVING users >= 3
ORDER BY
  2 DESC

結果テーブル

結果テーブル

サポートページに戻る