The following is an example of a Query that selects all above-average students as determined by a number grade:TABLE-US-00001 SELECT OBJECT(s) FROM StudentBean AS s WHERE s.grade > (SELECT AVG(s2.grade) FROM StudentBean AS s2)The syntax for a Subquery is the same as for a normal Query.