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 for users of Linux, FreeBSD and other Un*x-like operating systems

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