Skip to content

Instantly share code, notes, and snippets.

@ilyasahsan123

ilyasahsan123/top_10_stackoverflow_search.sql

Created August 20, 2018 03:57
Show Gist options
  • Save ilyasahsan123/dddfe46648cfa484fbc54b3e55925a59 to your computer and use it in GitHub Desktop.
Save ilyasahsan123/dddfe46648cfa484fbc54b3e55925a59 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
top_10_stackoverflow_search.sql
select tag
,count(*) number
from(
select SPLIT(q.tags, '|') tag
from [bigquery-public-data:stackoverflow.posts_questions] q
join [bigquery-public-data:stackoverflow.users] u
on q.owner_user_id = u.id
where REGEXP_MATCH(u.location, '(?i)indonesia')
)
group by tag
order by number desc
limit 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment