4

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

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

view current version

edited aug 9 14

created aug 6 14 TheBanana