Question editing percentage


Please login or register to vote for this query.

(click on this box to dismiss)


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

Switch to meta site
loading Hold tight while we fetch your results