Write the following SQL queries:

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

PhD students.

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

$3.$ Print the course names, course numbers and section numbers of all classes with

less than six students enrolled in them.

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

$5..$ Print the names of departments that have one or more majors who are under $18$

years old.

$6..$ Print the names and majors of students who are taking one of the College

Geometry courses. $($Hint: You'll need to use the "like" predicate and the string

matching character in your query.$)$

$7..$ For those departments that have no majors taking a College Geometry course,

print the department name and the number of PhD students in the department.

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

and a Mathematics course.

$9..$ Print the age difference between the oldest and youngest Computer Sciences

major$($s$).$

$10..$ For each department that has one or more majors with a GPA under $1\mathrm{.}0,$ print

the name of the department and the average GPA of its majors.

$11.$Print the ids, names, and GPAs of the students who are currently taking all of the

Civil Engineering courses.