Maks140888

Untitled

Jun 8th, 2022
1,355
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.48 KB | None | 0 0
  1. SELECT t.name, COUNT(DISTINCT c.name) FROM sheldule h, audiences a, corps c, subjects s, teachers t
  2.     WHERE c.id = a.corp_id
  3.     AND a.id = h.audience_id
  4.     AND s.id = h.subject_id
  5.     AND t.id = h.teacher_id
  6. GROUP BY t.name
  7. HAVING COUNT(DISTINCT c.name) =
  8.     (SELECT MAX(C) FROM (SELECT COUNT(DISTINCT c.name) AS C FROM sheldule h, audiences a, corps c, subjects s
  9.     WHERE c.id = a.corp_id
  10.     AND a.id = h.audience_id
  11.     AND s.id = h.subject_id
  12. GROUP BY h.teacher_id) AS Q)
Advertisement
Add Comment
Please, Sign In to add comment