Preguntas más respondidas.
Q&A about the site for science fiction and fantasy enthusiasts
DECLARE @anio int = ##Anno?2016##; DECLARE @mes int = ##Mes?1##; WITH Answers AS ( SELECT ParentId AS Id, max(Score) AS Score FROM Posts WHERE PostTypeId = 2 GROUP BY ParentId ) SELECT TOP 100 format(CURRENT_TIMESTAMP,'dd/mm/yyyy') "Creación", CONCAT('site://q/',Q.Id,'|',Q.Title) Pregunta, Q.AnswerCount "Cantidad de Respuestas", Q.Score "Puntaje de Pregunta", A.Score "Puntaje de Mejor Respuesta" FROM Posts Q LEFT OUTER JOIN Answers A ON Q.Id = A.Id WHERE 1=1 and Q.CreationDate >= CONCAT(@anio,'/',@mes+0,'/1') and Q.CreationDate < CONCAT(@anio,'/',@mes+1,'/1') ORDER BY 3 DESC, 5 DESC, 4 DESC, 1 DESC, Q.Title ASC ;