Skip to content

Instantly share code, notes, and snippets.

@isidroamv
Last active September 22, 2016 22:19
Show Gist options
  • Save isidroamv/41df5dd2a2e323e6e3caf861651c2177 to your computer and use it in GitHub Desktop.
Save isidroamv/41df5dd2a2e323e6e3caf861651c2177 to your computer and use it in GitHub Desktop.
A SQL query to get Questions and Answers of StackOverflow website. This data is required on the exercise 5 of the book Building Machine Learning Systems With Python
SELECT Id, Body, AcceptedAnswerId, Score, ParentId, CreationDate
FROM Posts
WHERE CreationDate BETWEEN '2014-01-01' AND '2017-01-01'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment