Percentage of users that filled in About Me

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

select
  Filled,
  Total,
  format((cast(Filled as float) / cast(Total as float)) * 100, 'N2') as [Percent]
from
  (
    select
    sum( iif(AboutMe = '', 1, 0) ) as Filled,
    count(*) as Total
    from
    users
  ) sub

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results