See Also: Main Page - Business Intelligence - Data Mining the StackOverflow Database

Guidelines for Adding New Queries

• Each new query needs to be a separate page. You can include notes on the query page about how to tweak the where clause or small changes like that.
• If your query relies on additional tables that aren't included in the article Understanding the StackOverflow Database Schema, then explain how to create the new tables as well. In your query article, point to the related article about your table.
• If your query relies on new features in SQL Server 2008, please note that. Otherwise, queries are assumed to work on SQL Server 2005 and newer.

Badge Queries

Comments Queries

Posts Queries

• StackOverflow Question Demographics Query - shows average score, average view count, average answers, etc across the entire site, or grouped by tag.
• StackOverflow Old Unanswered Questions Query - look for old questions that haven't had much activity. Jump in and answer 'em for a reputation boost.

Tag Queries

User Queries

Related Articles About the StackOverflow Database

• How to Import the StackOverflow XML into SQL Server
• Understanding the StackOverflow Database Schema
• Interesting StackOverflow Database Queries
• Data Mining with Excel - explains the basic concepts behind using Excel 2007 and SQL Server to do data mining. Not specific to StackOverflow, just general concepts.