Skip to content

Instantly share code, notes, and snippets.

@n1n9-jp

n1n9-jp/BigQuery.sql

Last active May 10, 2020 08:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save n1n9-jp/2ef6bd0a6154ddd15de7399a62db2fb4 to your computer and use it in GitHub Desktop.
Save n1n9-jp/2ef6bd0a6154ddd15de7399a62db2fb4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
BigQuery.sql
#【BigQuery】CREATE文を使えるの知ってた？SQLでテーブル作成｜ 開発者ブログ ｜ 株式会社アイソルート https://www.isoroot.jp/blog/1651/
#Google BigQuery の SQL文tips - 備忘録 blog http://sharply.hatenablog.com/entry/2019/04/15/000641
# example1
SELECT count(name)
FROM [プロジェクトID:tokyo_companies.company]
WHERE city = "千代田区"
# example2
SELECT city, count(company_number) AS company_number
FROM [プロジェクトID:tokyo_companies.company]
GROUP BY city
ORDER BY company_number DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment