Number of bounties opened and closed


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

with subquery as (select votetypeid, count(*) as number
from votes
where bountyamount is not null
group by votetypeid)

select name, number as "number of votes"
from subquery
inner join votetypes
on subquery.votetypeid =

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results