with p as ( select Posts.OwnerUserId as user_id from Po...

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 p as (

select Posts.OwnerUserId as user_id

from Posts

join Users

on Users.Id = Posts.OwnerUserId

where Posts.Tags like '%<sql>%'

and Posts.PostTypeId = 1

and year(Posts.CreationDate) = 2016

and Users.Location like '%Russia%'

group by Posts.OwnerUserId

)

select count(*) from p

where not exists(select 1 from Posts

where Posts.OwnerUserId = p.user_id

and Posts.PostTypeId = 1

and year(Posts.CreationDate) < 2016)

Enter Parameters

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