0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professionals and students of engineering

SELECT TOP 200 
    Id, 
    Reputation, 
    DATEDIFF(DAY, CreationDate, GETDATE()) AS AccountAgeDays,
    DATEDIFF(DAY, LastAccessDate, GETDATE()) AS DaysSinceLastAccess,
    UpVotes, 
    DownVotes, 
    Views, 
    (UpVotes - DownVotes) AS EngagementScore
FROM Users
WHERE 
    Reputation > 0
ORDER BY 
    Reputation DESC;

fork query

edited dec 2

created nov 30 anonymous