with base as (select distinct OwnerUserId,cast(creationDa...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Literature Meta

Q&A about the site for scholars and enthusiasts of literature

with base as (select distinct OwnerUserId,cast(creationDate as date) as ds from Posts)
select OwnerUserId, ds,lag(ds,1) over (partition by OwnerUserId order by ds) from base

Enter Parameters

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