Skip to main content
7 events
when toggle format what by license comment
Jan 18, 2021 at 12:14 history edited CommunityBot
replaced http://data.stackexchange.com/ with https://data.stackexchange.com/
Jun 29, 2012 at 23:55 vote accept blahdiblah
Apr 20, 2012 at 1:07 comment added Tim Stone (Note that in your query, you'd need to change COUNT(*) to COUNT(DISTINCT PostId) to get valid numbers, because a post may have more than one of those tags. The numbers would also not always end up at quite 100% because there are a few migrated posts in the mix that don't have any of those tags)
Apr 20, 2012 at 1:06 comment added Tim Stone My apologies, I didn't exclude answers in the query that was getting the total count. Seems I also overlooked that in the closed questions query. Modifying both raised the percentages, though in the case of the careers query the change wasn't too drastic.
Apr 20, 2012 at 1:00 history edited Tim Stone CC BY-SA 3.0
edited body
Apr 19, 2012 at 23:47 comment added blahdiblah Thank you for making that query! I'm not sure it's totally right though. I modified it to give the percentage of questions tagged with one of the four required meta tags (discussion/bug/support/feature-request), and the percentage never rises above 50%, while it should be more than 100% (as posts can have more than one of those tags). My SQL isn't brilliant either, so perhaps I made a mistake in the modification, but you might want to double-check those numbers.
Apr 19, 2012 at 19:12 history answered Tim Stone CC BY-SA 3.0