Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2017
44
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.14 KB | None | 0 0
  1. select f.fname
  2. ->from faculty
  3. ->where exists (select *
  4. ->from class c
  5. ->where c.fid = f.fid
  6. ->where count(f.fid) = distinct count(c.room);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement