firstnames for genders


Please login or register to vote for this query.

(click on this box to dismiss)

assumed first names from displayname of users active this year and other criteria, setup to extract by page number for export. It's a frikkin mess, don't look. lol Experimenting with PHP "Gender" Extension ( ... needed some sample data to play with. :-) Total output was about 20 pages (1 million names)

Russian Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

select top 500
  case when CharIndex( ' ', displayname )=0 then displayname else
  Substring( displayname, 1, CharIndex( ' ', displayname ) - 1)
  end as firstname,
  count(*) cnt
from users
group by displayname
order by cnt desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results