1

Please login or register to vote for this query.

(click on this box to dismiss)

Preguntas más respondidas.

Q&A about the site for developers and users of elementary OS and applications

WITH Answers AS (
  SELECT ParentId AS Id, max(Score) AS Score
  FROM Posts
  WHERE PostTypeId = 2
  GROUP BY ParentId
)

SELECT TOP 100
  /* questions joined with answers */
  format(Q.CreationDate,'dd/MM/yy') "Creación",
  Q.Id [Post Link],
  Q.AnswerCount "Cantidad de Respuesta",
  Q.Score "Puntuaje de Pregunta",
  A.Score "Puntaje de Respuestas"

FROM Posts Q
LEFT OUTER JOIN Answers A
  ON Q.Id = A.Id
WHERE
  Q.AnswerCount > 0
  AND Q.ClosedDate IS NULL
  AND Q.CreationDate >= '20160101'
ORDER BY
  3 DESC,
  5 DESC,
  4 DESC,
  1 DESC,
  Q.Title ASC

view current version

edited oct 6 16 ArtEze

created oct 4 16 Mariano