0

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackoverflow.com/q/316413

Q&A about the site for users of Wolfram Mathematica

select *
--,sum( case when posttypeid = 1 then 1 else null end)  [Questions]
--,sum( case when posttypeid = 2 then 1 else null end)  [Answers]
--,sum( case when posttypeid  in (1,2) then 1 else null end)  [Total]

from posts p
inner join posttags pt on pt.postid = coalesce(p.parentid, p.id)
inner join tags t on t.id = pt.tagid
inner join Users u on p.OwnerUserId = u.Id
where TagName like '%artificial-intelligence%'and

 lower(u.Location) like '%saudi%' or
(lower(u.Location) like '%saudi arabia%' 
)

fork query

edited aug 15 22 anonymous

created jul 25 22 rene