Inspect phrase distribution of recent user posts with low reputation

1

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

declare @past int = 2;
declare @Today smalldatetime = '2024-04-21 ';
declare @After smalldatetime = DATEADD(week, @past * -1, GETDATE()); 

with unit as (
  
  select top 100 
    id,creationDate

  from users u
  where 
    u.CreationDate > @after
    and reputation between 2 and 100

)

select 
  p.id,u.id,score,title,p.body,
  p.creationDate postDate, 
  u.creationDate signupDate 
from posts p 
inner join unit u on 
  p.OwnerUserId = u.Id -- or p.parentId = u.id
where 
  p.CreationDate > @after

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results