with personal_close_votes as ( select cast(count(Id) as f...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

with personal_close_votes as (
select cast(count(Id) as float) as personal_total from PostHistory where UserId = ##USERID##
), global_close_votes as (
select cast(count(Id) as float) as global_total from PostHistory
)

select (personal_total/global_total) * 100 from personal_close_votes,global_close_votes;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results