Preguntas más respondidas por mes

1

Please login or register to vote for this query.

(click on this box to dismiss)

Preguntas más respondidas.

Meta Stack Exchange

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

WITH Answers AS (
  /* unique answers with best score per question */
  SELECT ParentId AS Id, MAX(Score) AS Score
  FROM Posts
  WHERE PostTypeId = 2
  GROUP BY ParentId
)

SELECT
  /* questions joined with answers */
  format(Q.LastActivityDate,'dd/MM/yy') "Última Actividad",
  Q.Tags Etiquetas,
  CONCAT('http://es.stackoverflow.com/q/',Q.Id,'/127|',Q.Title) URL,
  Q.AnswerCount "Cantidad de Respuestas",
  Q.Score "Puntuaje de Pregunta",
  A.Score "Puntaje de Respuesta"

FROM Posts Q
LEFT OUTER JOIN Answers A
  ON Q.Id = A.Id
WHERE Q.PostTypeId = 1
  AND Q.AnswerCount > 0
  AND Q.AcceptedAnswerId IS NULL
  AND Q.ClosedDate IS NULL
  AND A.Score <= 0
ORDER BY A.Score            DESC,
         Q.Score            DESC,
         Q.LastActivityDate DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results