0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professionals, academics, and students working within the systems development life cycle

SELECT DisplayName AS 'Owner', Location, Title AS 'Question', Body, T.Score, Text AS 'Answer' FROM 
(
  SELECT TOP 10
  A.*,
  B.DisplayName,
  B.Location
  FROM Posts A 
  INNER JOIN Users B ON A.OwnerUserId = B.Id
  WHERE (A.PostTypeId = 1 AND B.Location LIKE 'Monterrey%')
  ORDER BY A.Score, DisplayName
) T
INNER JOIN Comments C ON C.PostId = T.Id
ORDER BY T.Score

fork query

edited dec 7 19

created dec 6 19 anonymous