new users first question

0

Please login or register to vote for this query.

(click on this box to dismiss)

Signal Processing Meta

Q&A about the site for practitioners of the art and science of signal, image and video processing

select top 10
  displayname,
  format(u.creationdate,'yyyy-mm') Joined,
  reputation Rep,
  upvotes,
  downvotes,
  upvotes+downvotes votes,
   count(q.creationdate) [VBAq's] /* ,
  min(q.creationdate) firstVBAquestion,
  ( select top 1 id z from posts z 
    where z.creationdate=q.creationdate
    and z.owneruserid=q.id
    and tags like '%vba>%') [Post Link] */
from posts q left join users u on u.id=q.owneruserid
where tags like '%vba>%'
and 
  (year(q.creationdate)-##numYearsBack:int?0## ) =year(getdate())
  and (year(u.creationdate)-##numYearsBack:int?0## ) =year(getdate())
  and closeddate is null
  and score>-5
  and posttypeid=1
group by 
  displayname,
  format(u.creationdate,'yyyy-mm'),
  reputation, upvotes, downvotes
order by min(q.creationdate) desc, upvotes+downvotes desc

-- numYearsBack: Number of years back (before this year): "😉"

Enter Parameters

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