Carrera por Epico y Legendario

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

SELECT Id AS [User Link], (
    SELECT Count (TotalRep)
      FROM (
               SELECT 
               SUM(votes.BountyAmount) as TotalRep,
                     Votes.CreationDate AS CreationDate
              FROM   Posts
                     INNER JOIN Votes
                       ON Votes.PostId = Posts.Id
                          
              WHERE  Posts.OwnerUserId = U.Id
                     AND Posts.CommunityOwnedDate IS NULL
              GROUP  BY Votes.CreationDate
      ) t
      WHERE TotalRep>=200) as Días
FROM Users U where U.Reputation >= 1000
ORDER BY 2 DESC

Enter Parameters

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