Advertisement
Maks140888

Untitled

Jun 8th, 2022
1,301
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.50 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
  9.         (SELECT COUNT(DISTINCT c.name) AS C FROM sheldule h, audiences a, corps c, subjects s
  10.         WHERE c.id = a.corp_id
  11.             AND a.id = h.audience_id
  12.             AND s.id = h.subject_id
  13.         GROUP BY h.teacher_id) AS Q)
  14.  
  15.  
  16.  
  17.        
  18.  
  19.  
  20.  
  21.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement