0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

create table #PostScores
(
 Score int
)

insert into #PostScores (Score)
select -1 union all
select 0 union all
select 1

select
 ps.Score,
 (select count(p.Id) from Posts p where p.Score = ps.Score)
from #PostScores ps

fork query

created jul 27 10 Simon Brown