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

set statistics time on
SELECT DisplayName AS 'Owner', Location, Title AS 'Question', Body, T.Score, Text AS 'Answer' FROM 
(
  SELECT TOP 10
  A.Id,
  B.DisplayName,
  B.Location,
  A.Title,
  A.Body, 
  A.Score
  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
) T
INNER JOIN Comments C ON C.PostId = T.Id
ORDER BY T.Score
set statistics time off

fork query

edited dec 7 19

created dec 6 19 anonymous