1. Print the names of professors who work in
departments that have fewer than 50 Ph.D. students.

    pname
-------------
 Edison, L.
 Brian, C.
 Jones, J.
 Smith, S.
 Walter, A.
 Bucket, T.
(6 rows)


2. Print the name(s) of student(s) with the lowest
gpa.

        sname
----------------------
 Jetplane, Leaving O.
(1 row)


3. For each Computer Sciences class, print the cno,
sectno, and the average gpa of the students enrolled in the class.

 cno | sectno |        avg
-----+--------+--------------------
 302 |      1 | 3.0000000000000000
 302 |      2 | 3.0750000000000000
 467 |      1 | 2.9800000000000000
 701 |      1 | 3.2833333333333333
 726 |      1 | 2.6411764705882353
(5 rows)


4. Print the course names, course numbers, and section
numbers of all classes with less than six students enrolled in them.

 cno | sectno |            cname
-----+--------+------------------------------
 561 |      1 | Advanced Garbage Collection
(1 row)

5. Print the name(s) and sid(s) of the student(s)
enrolled in the most classes.

    sname     | sid
--------------+-----
 Hamilton, S. |  29
(1 row)


6. Print the names of departments that have one or
more majors who are under 18 years old.

         dname
------------------------
 Industrial Engineering
 Mathematics
(2 rows)


7. Print the names and majors of students who are
taking one of the College Geometry courses. (Hint: use “like” predicate and the string
matching character in your query)

       sname       |        dname
-------------------+----------------------
 Ford, Gerald      | Chemical Engineering
 Austin, G.        | Chemical Engineering
 Mathews, John W.  | Chemical Engineering
 Dunbar, D.        | Civil Engineering
 Rosemeyer, S.     | Civil Engineering
 Atny, Mary H.     | Civil Engineering
 Glitch, R.        | Civil Engineering
 Ziebart, F.       | Civil Engineering
 Sulfate, Barry M. | Computer Sciences
 Cheong, R.        | Computer Sciences
 Thorton, James Q. | Computer Sciences
 Gooch             | Computer Sciences
 Smith, L.         | Computer Sciences
 Zappa, F.         | Mathematics
 Ghandi, I.        | Mathematics
 Uoiea, Z.         | Mathematics
 Sulfate, Barry M. | Sanitary Engineering
(17 rows)



8. Print the names of students who are taking both a
Computer Sciences course and a Mathematics course.

   sname
-----------
 Zappa, F.
(1 row)

9. Print the age difference between the oldest and
youngest Computer Sciences major(s).

 age_difference
---------------
             38
(1 row)

10.For each department that has one or more majors
with a GPA under 1.0, print the name of the department and the average GPA of
its majors.

         dname          |         avg
------------------------+--------------------
 Civil Engineering      | 2.9142857142857143
 Computer Sciences      | 3.0041666666666667
 Industrial Engineering | 2.7700000000000000
(3 rows)