Q&A about the site for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment
select -- count(closeddate), avg(year(creationdate)), avg(datediff(minute, creationdate, closeddate )*1.0) as life_time from Posts where score < 0 and closeddate is not Null and datediff(minute, creationdate, closeddate )*1.0 < 365*24*60 and year(creationdate)>=2009 group by year(creationdate)