ТБД первое задание

0

Please login or register to vote for this query.

(click on this box to dismiss)

Skeptics

Q&A for scientific skepticism

/*
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 PostTypeId=1
    ) 
  and Users.id in (
    select distinct(OwnerUserId) from Posts
    where Tags like '%<java%>' and PostTypeId=1
    )

Enter Parameters

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