0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Demographics of Users (average age)
SELECT avg(age + 0.0) as average,
sqrt(var(age)) as stderr,
(1 - (count(age) + 0.0) / count(*)) * 100 as missing_values_percentage
FROM Users
WHERE CreationDate < '2011-03-15 00:00:00'

fork query

edited jun 22 12

created jun 22 12 giraff