Print the names and majors of students who are taking one of the College Geometry courses
- AceTutor
- Rating : 33
- Grade : A+
- Questions : 0
- Solutions : 823
- Blog : 1
- Earned : $26606.70
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
[Solved] Print the names and majors of students who are taking one of the College Geometry courses
- This solution is not purchased yet.
- Submitted On 22 Dec, 2014 06:22:44
- AceTutor
- Rating : 33
- Grade : A+
- Questions : 0
- Solutions : 823
- Blog : 1
- Earned : $26606.70
This Tutorial is rated A+ p...
Print the names and majors of students who are taking one of the College Geometry courses
This Tutorial is rated A+ previously,if you have any questions regarding this tutorial than you can contact me.
...