New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Add StackOverflow data #9

Open

tjpalmer opened this issue Mar 8, 2020 · 1 comment

Owner

tjpalmer commented Mar 8, 2020

No description provided.

Owner Author

tjpalmer commented Oct 9, 2020

Here's a link for this:

https://console.cloud.google.com/bigquery?p=bigquery-public-data&d=stackoverflow&page=dataset

This might get the job done for question creation by quarter:

SELECT tags, extract(year FROM creation_date), extract(quarter FROM creation_date), count(*)  FROM `bigquery-public-data.stackoverflow.posts_questions`
group by tags, extract(year FROM creation_date), extract(quarter FROM creation_date)

It didn't like me sorting by year and quarter, though.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment