with c as ( SELECT P2.Id AS [Post Link], P1.Score as Answ...


Please login or register to vote for this query.

(click on this box to dismiss)

Portuguese Language

Q&A for linguists, teachers and learners wanting to discuss the finer points of the Portuguese language

with c as (
        P2.Id AS [Post Link], 
        P1.Score as AnswerScore,
        P2.Score as QuestionScore,

        P1.OwnerUserID AS [User Link]
FROM Posts as P1, Posts as P2
WHERE P2.Id = P1.ParentId and --Join of Questions with Answers--
      P2.PostTypeId = 1 and -- P2 Contains Questions --
      P1.PostTypeId = 2  -- P1 contains Answers --
      AND P2.OwnerUserID = P1.OwnerUserID
    --  AND   CAST (P2.id AS INT) +1 !=  CAST (P1.id AS INT)


      SELECT *

      FROM C
      ORDER BY AnswerScore DESC
 --     GROUP BY OverallAnswerAverage,OverallQuestionAverage,OverallViewAverage,OverallFavoriteCountAverage

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results