Number of bounties opened and closed

1

Please login or register to vote for this query.

(click on this box to dismiss)

Biblical Hermeneutics

Q&A for professors, theologians, and those interested in exegetical analysis of biblical texts

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 to meta site
loading Hold tight while we fetch your results