Preguntas elegantes

1

Please login or register to vote for this query.

(click on this box to dismiss)

Web Applications Meta

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
;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results