with sql_posts as( select distinct Posts.OwnerUserId as id

0

Please login or register to vote for this query.

(click on this box to dismiss)

Portuguese Language

Q&A for linguists, teachers and learners wanting to discuss the finer points of the Portuguese language

with sql_posts as(
select  distinct Posts.OwnerUserId as id
from Posts
join PostTags on PostTags.PostId = Posts.Id
join Tags on Tags.Id = PostTags.TagId
join Users on Users.Id = Posts.OwnerUserId
where Tags.TagName like '%sql%'
and Posts.PostTypeId = 1
and year(Posts.CreationDate) = 2016
and (Users.Location like '%Russia%' or Users.Location like '%Россия%'))

select count(id) from sql_posts where 
not exists (select 1 from Posts where Posts.OwnerUserid=sql_posts.id
and year(Posts.CreationDate)<2016)

Enter Parameters

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