select ssn, salary from Instructors where name = "I10"
select struct(x:ssn, y:salary) from Instructors where name = "I10"
select * from Instructors where ssn>10 and ssn<12
select c.code from e in Instructors, c in e.teaches where e.name = "I51"
select c from e in Instructors, c in e.degrees where e.name = "I51"
select c.name from c in Courses, d in c.is_prerequisite_for where d.name = "Fundamentals9"
select x:c.name, y:d.name from Courses c, c.is_prerequisite_for d where d.code = "C9"
select e.name from e in Instructors where e.ssn > 10 and e.ssn < 15 order by e.name
(select e from e in Instructors order by e.name)[10]
count(Instructors)
for all x in Instructors: x.salary >= 10000
exists x in Instructors: x.salary >= 50000
exists e in Instructors: for all c in e.teaches: e.ssn > 10 and c.name = "Fundamentals39"
element(select * from Instructors where ssn=78).teaches
select x: e.name from e in Instructors where e.name like "I1%8"
select e.dept.name from Instructors e where name = "I10"
select distinct e.dept.name from Instructors e where e.dept.head.name = "I79"
select x: e.name, y: e.dept.name from e in Instructors, s in e.dept.instructors, c in e.teaches where s.name = "I54" and c.name = "Fundamentals24"
select e.ssn, e.salary from (select n from n in Instructors where n.name = "I10") as e
select e.ssn from e in Instructors where exists c in e.teaches: c.offered_by.name = e.dept.name and e.name = "I68"
flatten(select e.teaches from e in Instructors where e.name = "I68")
select count(c.has_prerequisites) from c in Courses where c.name = "Fundamentals39"
select x: e.name, y: (select c.name from c in e.teaches) from e in Instructors where e.ssn = 56
select x: e.name, y: count(e.teaches) from e in Instructors where e.ssn = 56
select x: e.name, y: count(e.dept.instructors) from e in Instructors where e.ssn = 50
select x: e.name, y: (select x: c.name, y: count(c.has_prerequisites) from c in e.teaches) from e in Instructors where e.ssn = 56
select distinct x: dn, y: count(partition) from e in Instructors group by dn: e.dept.dno having dn = 6
select distinct x: dn, y: count(partition) from e in Instructors group by dn: e.rank
select distinct x: dn, z: count(partition) from e in Instructors group by dn: e.dept.name having dn = "D8"
select d.name, c: count(select * from e in d.instructors where e.rank = "professor") from d in Departments order by count(select * from e in d.instructors where e.rank = "professor")
select e.name, c: count(e.teaches) from e in Instructors where count(e.teaches) >= 3
select x, y, c: count(c) from e in Instructors, c in e.teaches group by x: e.ssn, y: c.name having x > 60 and y > "Fundamentals39"
select distinct x: x, y: count(e) from e in Instructors group by x: count(e.teaches) having x>0
select distinct x, y, c: count(e) from e in Instructors group by x: count(e.teaches), y: (exists c in e.teaches: c.name="Fundamentals39") having x>0
sum(select sum(select e.salary from e in d.instructors) from d in Departments)
select e.name, X: (select x from c in e.teaches group by x: count(c.has_prerequisites)) from d in Departments, e in d.instructors where d.name = "D8"
select e.ssn from e in Instructors where e.ssn > 30 and e.ssn < 78 and for all c in e.teaches: exists d in c.is_prerequisite_for: d.name = "Fundamentals12"
select e.ssn from e in Instructors where e.courses("D8") = 1
Instructors != Instructors
Instructors <= Instructors
max(select e.salary from e in Instructors)
select name: e.name, courses: (select c.name from c in e.teaches) from e in Instructors where e.name = "I94"