Installing the Oracle Client In Order To Connect to Banner/ODS
December 6, 2016
Using Task Scheduler To Open Outlook At Predefined Intervals, Using PowerShell
December 14, 2016

Most Popular Names at CSU

A friendly bet recently arose between a co-worker and myself as to what the most popular last name/first names were at CSU.  Here’s the query/results:

select
x.FIRST_NAME,
x.INSTANCES_OF_FIRST_NAME
from
(select
u.FIRST_NAME,
count(*) as INSTANCES_OF_FIRST_NAME,
rank() over (order by count(*) desc) as rank
from
CSUG_DIRECTORY_ALL u
group by
u.FIRST_NAME) x
where
x.rank <= 20

FIRST_NAMEINSTANCES_OF_FIRST_NAME
Michael3607
Matthew3117
Sarah2689
John2411
Christopher2388
Andrew2370
Ryan2334
Emily2298
David2272
Jessica2269
Daniel2173
Jennifer1999
Nicholas1927
James1901
Lauren1824
Elizabeth1816
Megan1782
William1703
Robert1666
Rachel1664

And Last Names:

select
x.LAST_NAME,
x.INSTANCES_OF_LAST_NAME
from
(select
u.LAST_NAME,
count(*) as INSTANCES_OF_LAST_NAME,
rank() over (order by count(*) desc) as rank
from
CSUG_DIRECTORY_ALL u
group by
u.LAST_NAME) x
where
x.rank <= 20

 

LAST_NAMEINSTANCES_OF_LAST_NAME
Smith1923
Johnson1651
Miller1227
Brown1122
Anderson902
Williams900
Jones893
Davis838
Lee716
Wilson703
Thompson636
Martinez636
Wang587
Taylor573
Martin571
Thomas564
Moore553
Zhang541
Nelson534
Li529