SELECT TOP 5000 Id as [User Link], DisplayName, Reputati...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Woodworking

Q&A for professional and amateur woodworkers

SELECT TOP 5000
  
  Id as [User Link],
  DisplayName,
  Reputation,
  QuestionCount as [Total Questions],
  CreationDate,
  Views,
  LastAccessDate,
  UpVotes,
  DownVotes,
  ROUND(CAST(100 * DownVotes AS float) / (UpVotes + Downvotes) , 1) * (UpVotes + Downvotes) as Ratio
  
  FROM Users
  
  inner join (
  -- Questions by each user
  select
    OwnerUserId,
    count(Id) as QuestionCount
  from posts
  where PostTypeId = 1
  group by OwnerUserId
) as Q on Users.Id = Q.OwnerUserId

  WHERE reputation > 100
  
    and UpVotes > 0
    
    and DownVotes > 10
  
  ORDER BY QuestionCount Desc

Enter Parameters

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