0

Please login or register to vote for this query.

(click on this box to dismiss)

How many questions per month does each tag in the top 10 tags get

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

select 
    q.id,
    q.tags,
    q.CommentCount,
    q.AnswerCount,
    q.FavoriteCount,
    a.body as answerbody
    
from posts q
inner join posts a 
  on a.id = q.acceptedanswerid
where 
  q.tags >5 
  and q.CommentCount>5
  and q.AnswerCount>10
  and q.FavoriteCount>5
  and q.tags like '%<python>%'

fork query

edited nov 9 anonymous

created jan 16 12 sam.saffron