0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for power users of web applications

SELECT
    MIN(LEN(q.Body)) AS MinQuestionLength,
    MAX(LEN(q.Body)) AS MaxQuestionLength,
    AVG(CAST(LEN(q.Body) AS FLOAT)) AS AvgQuestionLength,
    STDEV(LEN(q.Body)) AS StdDevQuestionLength -- Standard Deviation
FROM
    (
        SELECT
            Body
        FROM
            Posts
        WHERE
            PostTypeId = 1 AND -- 1 for Questions
            CreationDate >= DATEADD(YEAR, -1, GETDATE()) -- Questions from the past year
    ) q;

fork query

edited mar 7

created mar 7 jon.doe43979