DECLARE @minscroe int = ##minscore##; select count(*) fr...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Software Quality Assurance and Testing Meta

Q&A about the site for software quality control experts, automation engineers, and software testers

DECLARE @minscroe int = ##minscore##;
--DECLARE @UserId int = ##UserId##

--with pids as (select id from posts where score >=@minscroe)
select count(*) from votes v inner join posts p on v.postid = p.id
where 
    score>=@minscroe and
    votetypeid = 2

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results