Question editing percentage

1

Please login or register to vote for this query.

(click on this box to dismiss)

English

Q&A for linguists, etymologists, and serious English language enthusiasts

select count (*) as [Amount of Posts], 
count(lasteditdate) as [Amount of edits],
round(convert(float,count(lasteditdate))/count(*)*100,2) as [Editing percentage]
from posts
where posttypeid=1 
and closeddate is null 
and deletiondate is null

Enter Parameters

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