0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for enthusiasts and power users of the Android operating system

/*
select count(*) from Users 
where id not in(
  select distinct(OwnerUserId) from Posts 
  where year(CreationDate) = 2018 and PostTypeId = 1 and OwnerUserId is not null)
  */
  
  select count(*) from Users
  where Users.Reputation > 100 
  and Users.id in (
    select distinct(OwnerUserId) from Posts
    where Tags like '%sql%'
    ) 
  and Users.id in (
    select distinct(OwnerUserId) from Posts
    where Tags like '%java%'
    )

fork query

edited nov 12 19

created nov 12 19 anonymous