Inspired by MSO/q/111104/, I threw this together for the fun of it. Displays the most popular usernames and the number of users with that name. A name must have over 50 users to be counted.
Q&A for people studying math at any level and professionals in related fields
-- Enter Query Title
-- Enter Query Description
select displayname as Name, count(displayname) as 'Number of Users With This Name'
from users group by displayname
having count(displayname) > 50
order by count(displayname) desc