Number of occurrences of display names lengths

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT    U.range as [display name length],
          count(*) as [number of occurences],
          Round((U.range/600.0)*100,1) as [character limit percentage used]
FROM
(
SELECT len(replace(displayname,' ','')) as range
  FROM   Users
  WHERE displayname != '' and displayname is not null
) U
GROUP BY U.range
ORDER BY U.range

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached