select top 2000 p.id [Post Link], p.Score from Posts p wh...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 2000
  p.id [Post Link],
  p.Score
from Posts p
where p.PostTypeId = 1
  and p.Score > 10
  and
  (
    p.Body like '%Consider a%'
    or
    p.Body like '%part 1%'
    or
    p.Body like '%assignment%'
  )
order by p.Score desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results