0

Please login or register to vote for this query.

(click on this box to dismiss)

On avg how often are answers I give, accepted

Q&A about the site for enthusiasts and scholars of mythology and folklore

-- What is my accepted answer percentage rate
-- On avg how often are answers I give, accepted

SELECT
    Id,
    DisplayName,
    CreationDate,
    LastAccessDate,
    POWER(Reputation, 1.5) / NULLIF(
        DATEDIFF(day, CreationDate, LastAccessDate), 0
    ) AS ReputationRatio
FROM 
    USERS
ORDER BY 
    ReputationRatio DESC;

fork query

edited oct 22 anonymous

created may 25 10 sam.saffron