MyLibrary Demographics
Totals for Thursday, August 28, 2008
--------------
select count(distinct suid) as totals, colleges.college_name from patrons natural left join colleges where disabled is null group by patrons.college_id order by totals desc limit 25
--------------
+-----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| totals | college_name |
+-----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 10 | College of Arts & Sciences |
| 10 | Other |
| 9 | Maxwell School of Citizenship & Public Affairs |
| 8 | School of Information Studies |
| 5 | School of Management |
| 5 | School of Education |
| 4 | College of Engineering & Computer Science |
| 4 | College of Visual & Performing Arts |
| 3 | College of Human Services & Health Professions |
| 2 | Newhouse School of Communications |
| 2 | College of Law |
| 1 | NULL |
+-----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
--------------
select count(distinct suid) as totals, disciplines.discipline_name from patrons natural left join disciplines where disabled is null group by patrons.discipline_id order by totals desc limit 25
--------------
+-----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| totals | discipline_name |
+-----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 7 | Library and Information Science |
| 6 | Business and Management |
| 5 | Education |
| 5 | Public Administration |
| 4 | Anthropology and Archaeology |
| 3 | Computer Science |
| 3 | Music and Dance |
| 3 | Philosophy |
| 2 | Art and Design |
| 2 | Communication Studies |
| 2 | Environmental Sciences |
| 2 | History |
| 2 | Law |
| 2 | Mathematics and Mathematical Statistics |
| 1 | NULL |
| 1 | Biological Sciences |
| 1 | Chemistry |
| 1 | Electrical Engineering |
| 1 | Exercise Science and Physical Education |
| 1 | Film |
| 1 | Forestry and Agriculture |
| 1 | General Science and Technology |
| 1 | General Sources |
| 1 | International Relations |
| 1 | Political Science |
+-----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
--------------
select count(distinct suid) as totals, ranks.rank_name from patrons natural left join ranks where disabled is null group by ranks.rank_id order by totals desc limit 25
--------------
+-----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| totals | rank_name |
+-----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 34 | student - graduate |
| 10 | student - undergraduate |
| 9 | faculty |
| 4 | staff |
| 3 | librarian |
| 2 | NULL |
| 1 | other |
+-----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
