Q&A about the site for power users of web applications
WITH Answers AS ( SELECT ParentId AS Id, SUM(Score) AS Score FROM Posts WHERE PostTypeId = 2 GROUP BY ParentId ) SELECT TOP 1700 Q.Id [Post Link], Q.AnswerCount "Cantidad de Respuestas", Q.Score "Puntuaje de Pregunta", A.Score "Puntaje de Respuestas", 1500*Q.Score/(Q.Score+A.Score)-500 "Elegancia" FROM Posts Q LEFT OUTER JOIN Answers A ON Q.Id = A.Id WHERE Q.PostTypeId = 1 AND Q.AnswerCount > 0 AND Q.AcceptedAnswerId > 0 AND Q.ClosedDate IS NULL AND A.Score > 0 AND Q.Score > 0 AND CONVERT(FLOAT,Q.Score)/CONVERT(FLOAT,A.Score+Q.Score) >= 0.25 ORDER BY 5 DESC, 2 DESC, 3 DESC, 4 DESC, Q.Title ASC ;