Badges earnt on 2011-07-07

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow en español

Preguntas y respuestas para programadores y profesionales de la informática

select /* b.UserId As [User Link],*/ Name, count(*) as [Count], count(distinct b.UserId) As [User Count], min(b.date) as [First], max(b.date) as [Last]
  from badges b
  -- where CAST(b.date as Date) = '2011-07-07'
  group by b.Name, CAST(b.date as Date) --, b.UserId
  having count(*)>1000 and Name not like '% Question'
  order by min(b.date)

Enter Parameters

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