select count(e.teaches) from e in Employees where count(e.teaches) > 0the count(e.teaches) (an unnest followed by a nest) is translated once.
exists x in Instructors: for all c in x.teaches: x.name = "Smith" and c.name="DB"
select d.name from d in Departments order by count(select * from e in d.instructors where e.rank = "Full Professor")
Last modified: 11/13/01 by Leonidas Fegaras