Good answer vs includes code

0

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

select case when a.score > 0 or a.id = q.acceptedanswerid then 'yes'
            else 'no' end as GoodAnswer
     , case when q.body like '%<code>%' then 'yes'
            else 'no' end as IncludesCode
     , count(*) as Count
  from posts q
  join posts a
    on q.id = a.parentid
 where q.posttypeid = 1
   and a.posttypeid = 2
   and q.viewcount > 10
   and q.answercount > 0
   and q.creationdate > ( select max(creationdate)
                           from posts ) - 30
 group by case when a.score > 0 or a.id = q.acceptedanswerid then 'yes'
               else 'no' end
        , case when q.body like '%<code>%' then 'yes'
               else 'no' end
 order by case when a.score > 0 or a.id = q.acceptedanswerid then 'yes'
               else 'no' end

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results