In this assignment, you will use the data from the previous assignments. You are required to develop the SQL queries for the following:
1. 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.)
2. 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.