SQL> start lab6 SUM(ENROLLED) ------------- YEAR SUM(ENROLLED) COUNT(*) ---------- ------------- ---------- 1935 7285 6 1936 7329 6 1937 7883 6 1938 9140 6 1939 10143 6 1940 10106 6 1941 8932 6 1942 6746 6 1943 4636 6 1944 5034 6 1945 7907 6 1946 15037 6 1947 20753 10 1948 25636 10 1949 30502 11 1950 30502 11 1951 31568 11 1952 34169 11 1953 40294 11 1954 46561 11 1955 54618 11 1956 65001 14 1957 73208 15 1958 81140 15 1959 86496 16 1960 94837 17 1961 104795 17 1962 118201 17 1963 131718 17 1964 146651 17 1965 154312 19 1966 168813 19 1967 185002 19 1968 205457 19 1969 225537 19 1970 242465 19 1971 259185 19 1972 273465 19 1973 281678 19 1974 289072 19 1975 303429 19 1976 298604 19 1977 303946 19 1978 296875 19 1979 299987 19 1980 307456 19 1981 308545 19 1982 307903 19 1983 306094 19 1984 309190 19 1985 318817 19 1986 328321 19 1987 336801 19 1988 348067 19 1989 355073 19 1990 362221 20 1991 353651 20 YEAR SUM(ENROLLED) COUNT(*) ---------- ------------- ---------- 1992 333647 20 1993 316478 20 1994 313394 21 1995 320033 22 1996 330527 22 1997 336672 22 1998 344394 22 1999 353392 22 2000 362286 22 2001 382151 22 2002 397400 23 2003 394770 23 2004 387889 23 70 rows selected. NAME AVG(E.UG) AVG(E.GR) ---------------------------------------- ---------- ---------- Computer and Info. Sciences 557.952381 97.9047619 Education 836.190476 736.619048 Mathematics 156.363636 48.5909091 Physical Sciences 175.05 39.2 Social Sciences 1096 137.217391 Home Economics 278.461538 59.8461538 Communications 657.190476 31.8571429 Fine and Applied Arts 863.272727 62.9545455 Biological Sciences 679.619048 49.1904762 Foreign Languages 114.25 25.3 Area Studies 36 18.6666667 Letters 630.363636 156.454545 Psychology 831.047619 70.0952381 Undeclared 1168.40909 1.95454545 Architecture 367.5 45.875 Health Professions 869.235294 250.529412 Agriculture 668.875 40.875 Interdisciplinary Studies 1193.73913 37.7391304 Public Affairs 756 237.75 Engineering 1383.88235 248.470588 Library 0 661 Business and Management 2672.56522 208.608696 22 rows selected. no rows selected CAMPUS TOTAL ------------------------------------------------------------ ---------- San Diego State University 79376 CAMPUS FACULTY STUDENTS RATIO ------------------------------------------------------------ ---------- ---------- ---------- California Maritime Academy 78.1 872 11.1651729 CAMPUS ENG_PERCENTAGE ------------------------------------------------------------ -------------- California Maritime Academy 36.7897727 CAMPUS YEAR ENROLLED YEAR ENROLLED ------------------------------------------------------------ ---------- ---------- ---------- ---------- Fresno State University 2003 21141 1943 987 California State University-Fullerton 2004 33079 1958 284 San Diego State University 1987 36017 1943 860 California State University-San Bernardino 2002 16298 1965 290 California State University-East Bay 2002 13400 1959 313 Humboldt State University 1991 7779 1943 159 California State University-Bakersfield 2003 7597 1956 384 California State University-Chico 2001 16468 1943 284 San Francisco State University 1990 28959 1943 914 California Polytechnic State University-San Luis Obispo 2002 17838 1952 2085 Sonoma State University 2003 8099 1956 184 California State University-Stanislaus 2002 7431 1965 681 California State University-Northridge 2002 33028 1956 1624 California State Polytechnic University-Pomona 2002 19232 1951 317 San Jose State University 1990 29879 1943 1432 California State University-Los Angeles 1975 24072 1947 238 California State University-Sacramento 2002 27759 1947 414 California State University-Dominguez Hills 2002 13244 1965 44 Long Beach State University 1987 34194 1949 432 19 rows selected. YEAR CAMPUS ---------- ------------------------------------------------------------ 1960 California State University-East Bay 1961 California State University-Fullerton 1962 Sonoma State University 1963 Sonoma State University 1964 California State University-East Bay 1965 California State University-Fullerton 1966 California State University-Dominguez Hills 1967 California State University-Dominguez Hills 1968 California State University-Dominguez Hills 1969 California State University-Dominguez Hills 1970 California State University-Dominguez Hills 1971 California State University-Bakersfield 1972 California State University-Bakersfield 1973 California State University-Dominguez Hills 1974 California State University-Dominguez Hills 1975 California State University-Dominguez Hills 1976 California State Polytechnic University-Pomona 1977 California State University-San Bernardino 1978 California State Polytechnic University-Pomona 1979 California State University-Stanislaus 1980 California State University-Stanislaus 1981 California State University-East Bay 1982 California State University-San Bernardino 1983 California State University-San Bernardino 1984 California State University-San Bernardino 1985 California State University-San Bernardino 1986 California State University-San Bernardino 1987 California State University-San Bernardino 1988 California State University-San Bernardino 1989 California State University-San Bernardino 1990 California State University-San Bernardino 1991 California State University-San Marcos 1992 California State University-San Marcos 1993 California State University-San Marcos 1994 California State University-San Marcos 1995 California State University-San Marcos 1996 California State University-Monterey Bay 1997 California State University-Monterey Bay 1998 California State University-Monterey Bay 1999 California Maritime Academy 2000 California State University-Monterey Bay 2001 California State University-Monterey Bay 2002 California State University-Monterey Bay 2003 California State University-Channel Islands 2004 California State University-Channel Islands 45 rows selected. SQL> spool off