Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT t.name, COUNT(DISTINCT c.name) FROM sheldule h, audiences a, corps c, subjects s, teachers t
- WHERE c.id = a.corp_id
- AND a.id = h.audience_id
- AND s.id = h.subject_id
- AND t.id = h.teacher_id
- GROUP BY t.name
- HAVING COUNT(DISTINCT c.name) =
- (SELECT MAX(C) FROM
- (SELECT COUNT(DISTINCT c.name) AS C FROM sheldule h, audiences a, corps c, subjects s
- WHERE c.id = a.corp_id
- AND a.id = h.audience_id
- AND s.id = h.subject_id
- GROUP BY h.teacher_id) AS Q)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement