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.

Here is the tables...

Student(sid,sname,sex,age,year,qpa)
Dept(dname,numphds)
Prof (pname,dname)
Course (cno,cname,dname)
Major(dname,sid)
Section(dname,cno,sectno,pname)
Enroll(sid,grade,dname,cno,sectno)

Primary Keys = sid, dname, pname, cno, sectno,

Answer rating: 100% (QA)

1 SELECT DISTINCT sname major FROM Student Dept Prof Course M... View the full answer