1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

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(*)

fork query

edited jul 13 Tschallacka

created jul 19 17 rene