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 members 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 );