0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

select count(case when FavoriteCount >= 100 then 1 
                  else null end ) as [Stellar Question]
     , count(case when FavoriteCount >= 25 then 1 
                  else null end ) as [Favorite Question]
     , count(case when FavoriteCount >= 10 then 1 
                  else null end ) as [Worthy Question]
  from posts
 where PostTypeId = 1

fork query

created aug 18 12 anonymous