Print the names and majors of students who are taking one of the College Geometry courses

Question: #416

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.

Attached is the info needed to make the SQL file. It needs to be in SQL

Solution: #436

Print the names and majors of students who are taking one of the College Geometry courses

A+ grade guaranteed! I always give g...