0

Please login or register to vote for this query.

(click on this box to dismiss)

find unanswered question of highschool level

Q&A for people studying math at any level and professionals in related fields

select
q.Id,q.title ,'https://math.stackexchange.com/questions/'+cast(q.id as varchar(16)),
q.Tags
from
    Posts q
  inner join
    Users u
  on u.Id = q.OwnerUserId
where
  q.PostTypeId = 1
  and q.AnswerCount =0
  and q.Tags like'%'+'##Tag##'+'%'
  and q.ClosedDate is Null 
  and q.DeletionDate is Null
  and (lower(u.AboutMe) like '%highschool%'
  or lower(q.Body) like '%highschool%')
  order by q.LastEditDate desc

fork query

edited jun 15 17

created jun 15 17 anonymous