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
- This solution has not purchased yet.
- Submitted On 22 Dec, 2014 06:22:44