0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in the history and origins of science and mathematics

with badge as (select count(*) as color, userid, name
               from badges b
               join tags t on t.tagname = b.name
               group by userid, name)
select count(*) from badge
where color = 1

view current version

edited may 23 14

created may 23 14 Olaf Dietsche