palantir-foundry users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Spanish Language

Q&A for linguists, teachers, students and Spanish language enthusiasts in general wanting to discuss the finer points of the language

select
      t.tagname, count (distinct p.owneruserid) as Users
  from users u, posts p, posttags pt, tags t
  where
        p.owneruserid = u.id
    and p.posttypeid = 2
    and p.score > 0
    and p.creationdate <'2021-01-01 00:00:00'
    and pt.postid=p.ParentId
    and t.id = pt.tagid 
    and (t.tagname='palantir-foundry')
  group by t.tagname
  
  
   select
      t.tagname, count (*) as NumAnswers
  from users u, posts p, posttags pt, tags t
  where
        p.owneruserid = u.id
    and p.posttypeid = 2
    and p.score > 0
    and pt.postid=p.ParentId
    and t.id = pt.tagid 
    and p.creationdate <'2021-01-01 00:00:00'
    and (t.tagname='palantir-foundry')
  group by t.tagname

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results