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,
 count(p.Id)
from #PostScores ps
inner join Posts p on p.Score = ps.Score
group by ps.Score

fork query

created jul 27 10 Simon Brown