Student(snum: integer, sname: string, major: string, level: string, age: integer

Question

Student(snum: integer, sname: string, major: string, level: string, age: integer) Class(name: string, meets at: string, room: string, d: integer) Enrolled(snum: integer, cname: string) Faculty(d: integer, fname: string, deptid: integer)

Give the above, I need a solution to the following problem for MySQL Workbench.   For each faculty member that has taught classes only in room R128, print the faculty member’s name and the total number of classes she or he has taught.

Do not send me the solution below - which is everywhere because it does not work in MySQL Workbench.

SELECT F.fname, COUNT(*) AS CourseCount

FROM Faculty F, Class C

WHERE F.d = C.d GROUP BY F.d, F.fname

HAVING EVERY ( C.room = ‘R128’ );

Explanation / Answer

###INSERTIONS:

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects