users assigned caucus badge between dates

1

Please login or register to vote for this query.

(click on this box to dismiss)

Open Data

Q&A for developers and researchers interested in open data

select b.name,
    CONVERT(VARCHAR(10), b.Date, 111) [date]
     , count(*) [number of users]
from users u
inner join badges b on b.userid = u.id
where b.name = ##badgename:string?Caucus## collate SQL_Latin1_General_Cp1_ci_ai
and b.Date >= CONVERT(DATETIME, ##begindate:string?2020-07-06##,102)
and  b.Date <= CONVERT(DATETIME, ##enddate:string?2020-07-13##,102)
and tagbased = 0
group by b.name, b.class, CONVERT(VARCHAR(10),b.Date, 111)
order by count(*)

Enter Parameters

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