0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

select count(*), avg(cast(score as float)), count(ClosedDate)
     , min(score), max(score)
  from Posts
 where PostTypeId = 1
   and patindex('%please%', lower(title)) > 0
   and datepart(year, CreationDate) = 2012
   and score < 40

fork query

edited nov 22 12

created nov 22 12 anonymous