gistfile1.txt

MariaDB [DEGREES]> SELECT cip,cipTitle,SUM(count) FROM degrees NATURAL JOIN cip WHERE year=2010 AND school=186131 and variable="TOTAL" AND level=5 GROUP BY cip;
+---------+----------------------------------------------------------------------+------------+
| cip     | cipTitle                                                             | SUM(count) |
+---------+----------------------------------------------------------------------+------------+
|  4.0201 | Architecture.                                                        |         15 |
|  5.0104 | East Asian Studies.                                                  |         10 |
|  5.0108 | Near and Middle Eastern Studies.                                     |         13 |
| 14.0701 | Chemical Engineering.                                                |         36 |
| 14.0801 | Civil Engineering, General.                                          |         18 |
| 14.0901 | Computer Engineering, General.                                       |         44 |
| 14.1001 | Electrical and Electronics Engineering                               |         31 |
| 14.1901 | Mechanical Engineering.                                              |         37 |
| 14.3701 | Operations Research.                                                 |         55 |
| 16.0104 | Comparative Literature.                                              |         26 |
| 16.0400 | Slavic, Baltic and Albanian Languages, Literatures, and Linguistics. |         16 |
| 16.0501 | German Language and Literature.                                      |          5 |
| 16.0901 | French Language and Literature.                                      |         10 |
| 16.0905 | Spanish Language and Literature.                                     |          8 |
| 16.1200 | Classics and Classical Languages, Literatures, and Linguistics.      |         32 |
| 23.0101 | English Language and Literature, General.                            |         58 |
| 26.0204 | Molecular Biology.                                                   |         56 |
| 26.1301 | Ecology.                                                             |         37 |
| 27.0101 | Mathematics, General.                                                |         31 |
| 30.9999 | Multi-/Interdisciplinary Studies, Other.                             |          2 |
| 38.0101 | Philosophy.                                                          |         43 |
| 38.0201 | Religion/Religious Studies.                                          |         32 |
| 40.0202 | Astrophysics.                                                        |          6 |
| 40.0501 | Chemistry, General.                                                  |         33 |
| 40.0699 | Geological and Earth Sciences/Geosciences, Other.                    |          4 |
| 40.0801 | Physics, General.                                                    |         29 |
| 42.0101 | Psychology, General.                                                 |         56 |
| 44.0501 | Public Policy Analysis, General.                                     |         76 |
| 45.0201 | Anthropology.                                                        |         40 |
| 45.0601 | Economics, General.                                                  |         97 |
| 45.1001 | Political Science and Government, General.                           |        102 |
| 45.1101 | Sociology.                                                           |         42 |
| 50.0703 | Art History, Criticism and Conservation.                             |         25 |
| 50.0901 | Music, General.                                                      |          7 |
| 54.0101 | History, General.                                                    |         80 |
+---------+----------------------------------------------------------------------+------------+