4

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for serious players and enthusiasts of chess

SELECT Users.Id as [User Link], Users.Reputation, Users.CreationDate, Users.LastAccessDate, 
       Users.Views, Users.UpVotes, Users.AboutMe
FROM Users
WHERE Users.Reputation < 30
  AND Users.Reputation >= 10
  AND Users.UpVotes >= 10
  AND Cast(Users.CreationDate as Date) = Cast(Users.LastAccessDate as Date)
  AND Users.Id NOT IN (
    SELECT OwnerUserId 
    FROM Posts
    WHERE OwnerUserId IS NOT NULL
    GROUP BY OwnerUserId
  )
ORDER BY CreationDate

fork query

edited aug 9 14

created aug 6 14 TheBanana