Number of bounties opened and closed

1

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 = votetypes.id

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached